Forum Discussion
Excel 365 + macOS - changing separator !
There is simply no way to successfully change separator in MS Excel on macOS. I want to have my numbers formatted like that: 1.000.000,01. And I cannot do that for years on macOS, and it is so ea...
Biuro Well, a Mac differs quite a bit from a PC. But you can certainly set the list separator and decimal symbol in MacOS. It's not in any way more difficult than on a PC.
Apple symbol (top left)
System Preferences...
Language & Region
Advanced...
On the General tab, set the grouping and decimal symbols as you desire for both numbers and the currency format. Press OK
Close the settings window.
Restart Excel in case you had it open.
- Did that, does not work. I even do that every time I have new mac, work's everywhere, but not on MS Office.
Biuro Works for me. Have no other suggestions. Sorry.
