If you want to change the thousand and decimal separator in Excel for Mac, you need to change it at operating system level.
For example I have Leopard in English and Excel 2004 in Italian and I have changed the decimal separator from .(dot) to ,(comma).
How to proceed:
0) close excel for mac
1) open mac os system preferences from the dock
2) open Personal, International
3) go to format
4) select a region where the comma separator is used, for example United Kingdom. In the bottom of the popup window, the numbers should appear in the correct format
5) relaunch excel for mac
15 comments:
This does not work in general.
Excel is just a bad program.
The format *is* displayed correctly within the International part of my computer settings, but still Excel uses the stupid comma.
This is also not working for me. If anyone has found a soluiton please let me know. I prefer numbers anyways but need use excel (Crap) for one assignment.
In personal, under format, you'll also need to change the last bar between american or naitiv metrics.
Thanks! This worked!!!
It does work, just be sure to quit Excel before making changes. Thanks a Lot!
It does work, just be sure to quit Excel before making the changes. Thanks a lot!
Hello
This post was interesting, how long did it take you to write?
Perfect, I spend some time looking for the solution. Thanks!
Close excel. Open system preferences from the dock, open language&text, formats, and customize the number settings. :)
thanks for your post! was really helpfull for me.
Bests,
Cheers! I love MAC!!!
You just saved my life.
Thanks for the post. Saved lots of my time. It works, this is what I did:
1. System Preferences
2. Language & Text
3. Formats
4. Numbers => Customize
5. Adjust Decimal/Thousands for Number Separators / Currency Separators
6. OK
7. Re-start mac
THANK YOU! Helped me!
for french keyboard layout same behaviour ...
works with Lion, not with tiger
Post a Comment