Hello
I wonder if anybody can help?
I create a lot of automated reports. These reports include costing and
percentages, with several decimal places. In the English format the "1000
Seperator" is a comma, and the decimal places are seperated with a dot.
Now the problem:
I have to send the reports to clients in mainland Europe, where the "1000
Seperator" is a dot, and the decimal places are seperated with a comma.
So far I could only remove the "1000 Seperator" entirely (in Format cells),
send it to the Europeans, and they had to change the Comma on the decimal
palces manually. Sometimes this is very difficult, since Excel in Europe
treats that dot like a "1000 Seperator", and removes the 0 in front of the
dot.
I cannot ask them to change their country setting, since they need to use
their country specific settings for everything they are doing. ALso I cannot
change my settings, since I work with English/America clients also.
Is there any way to automatically transfer the commas into dots, and vise
versa?
Thanx
Bookmarks