Forum Discussion
JPMFly
Feb 04, 2024Copper Contributor
Cannot find how to setup "." as the decimal symbol instead of ","
Hello, I used to be a Windows user, now I use Excel under MacOS. I'm in France, so the standard number format is 123 456,xx. But I prefer to have 123 456.xx. It was easy to do it in my previous conf...
Riny_van_Eekelen
Feb 04, 2024Platinum Contributor
JPMFly You'll find it under 'Apple logo', System Preferences..., Language and Region, Advanced, General.
I'm still on Monterey, so it may look different if you are on a more modern MacOS
- JPMFlyFeb 04, 2024Copper Contributor
hello Riny_van_Eekelen
thank you for your answer!
I did it already. I choose 1 234 567.99 as format but it didn’t change the behavior in Excel…. It still considers an entry like 123.45 as a text string and not as a number.
I’m on SONOMA as I just bought my Mac two weeks ago.