decimal separator

[MP]

I use excel for mac (OS X) in a french version. In the
french system, the separator for decimals is a , (coma)
instead of a . (dot). I need to work with an american
system, with dots. But I couldn't find how I can change
this in excel. I tried to change the system preferences (in
International/Numbers), but it had no effect even after
restarting the computer.

Thanks for your help

M.

 

[Bernard Rey]

MP wrote :

I use excel for mac (OS X) in a french version. In the
french system, the separator for decimals is a , (coma)
instead of a . (dot). I need to work with an american
system, with dots. But I couldn't find how I can change
this in excel. I tried to change the system preferences (in
International/Numbers), but it had no effect even after
restarting the computer.

Works as expected in my case (Mac OS X 10.3.5). No need to restart the
computer, relaunching Excel should be enough. Maybe you could trash some
corrupted preference files? How does it run in the system Calculator.app?

 

[Guest]

-----Original Message-----
I use excel for mac (OS X) in a french version. In the
french system, the separator for decimals is a , (coma)
instead of a . (dot). I need to work with an american
system, with dots. But I couldn't find how I can change
this in excel. I tried to change the system preferences (in
International/Numbers), but it had no effect even after
restarting the computer.

Thanks for your help

M.
.

Go to the TOOLS menu and select OPTIONS.
Select the "International" tab.
Under "Number Handling" UNCHECK "Use System Seperators."
Type in the character you want to use as "Decimel
Seperator" and/or "Thousands Seperator".

Works on this end.

 

[JE McGimpsey]

Go to the TOOLS menu and select OPTIONS.
Select the "International" tab.
Under "Number Handling" UNCHECK "Use System Seperators."
Type in the character you want to use as "Decimel
Seperator" and/or "Thousands Seperator".

Works on this end.

I suspect that end is using Windows, right? It's a little different here
in the mac groups.

MacXL takes the decimal separator from the system settings (System
Preferences/International/Formats/Numbers/Customize...). AFAIK, there's
no way to adjust XL's usage independently.