Jump to content
Sign in to follow this  
Fantasia83

coma separator problem

Recommended Posts

Hye all,

I'm in trouble with the decimal separator.

I'm using RemoteAccess 9.0.1 on Windows 7.

I read some operands Values the export them into excel file. It seems that the MF decimal point disappear.

When i open Excel 2007 and import the File previously generated with RemoteAccess, all the decimal separator has disappeared.

The only way i founded is to change the separator type on windows Control Pannel as a point instead of a coma (We are in France)

This is not convenient, i don't want to change our customers system setting like this one.

Maybe i'm wrong but i think remote access don't use comma as decimal separator but as object/cell separator.

Is there another way ? or an option in Remote access to use comma as decimal separator ?

Thank you

Share this post


Link to post
Share on other sites

Hi,

This is an issue regarding the Excel settings.

In Excel, go to:

Control panel > Local settings.

At the Local Options tab, click on Customize and change the "." with a ",".

Share this post


Link to post
Share on other sites

Thx for reply Stein,

1) Decimal system separator = ","

i tried to change the excel separator as "." but nothing changed.

Ex : I've got MF10 = 40.7437 and MF11 = 40.42034 before exporting them.

After Importing into PLc, values are MF11 = 4.07E5 and MF11 = 4.04E6 ??

2) Decimal system separator "." and everything is OK !

All decimal values are exported and imported correctly !!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...