Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 29th 05, 09:56 AM
xenia
 
Posts: n/a
Default Change Dots into Commas as Decimal Divider

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

  #2   Report Post  
Old April 29th 05, 02:18 PM
Marty
 
Posts: n/a
Default

You said: “I cannot ask them to change their country setting..." I'm not
sure this is what you're talking about or not so I apologize in advance if
you are. When I went in to Control Panel Regional and Language Options
Customize I changed the “.” to a "," for decimal numbers. Then I changed ","
for a "." for 1000 separator. Then I opened Excel, typed in a number and the
number looked like this: 120.000.000,00; just what I expected. I saved the
WS; changed the settings back to the way the were; then I reopened the WS and
the number appeared like this: 120,000,000.00. It would seem to me that if
everyone had their Regional Settings in Control Panel set to their specific
country's format nobody would have to change anything. Have you explored
this option?

Marty

"xenia" wrote:

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

  #3   Report Post  
Old August 8th 05, 09:48 AM
szymon
 
Posts: n/a
Default


hi,
you may try changing the setting for decimal places in
tools/options/international from commas to dots and save the document
in this setting.
hope this's helped......


--
szymon
------------------------------------------------------------------------
szymon's Profile: http://www.excelforum.com/member.php...o&userid=26030
View this thread: http://www.excelforum.com/showthread...hreadid=366891



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change a text fraction. eg 1 1/2 into a decimal number, . antac Excel Worksheet Functions 1 February 28th 05 05:02 PM
Change decimal format of cells depending on conditions? Cornelius Excel Worksheet Functions 1 February 25th 05 12:57 AM
How do I change the number of decimal places displayed in Excel Dan Excel Discussion (Misc queries) 1 February 23rd 05 10:31 PM
How do I override fixed decimal place settings in EXcel 2003? jroyv Excel Worksheet Functions 2 February 11th 05 06:07 PM
How can I change decimal amounts to end with .95 naclu Excel Worksheet Functions 2 January 11th 05 05:58 PM


All times are GMT +1. The time now is 01:42 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017