Cannot find how to setup "." as the decimal symbol instead of ","

Question

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 configuration, now I cannot find it. Could you tell me how to get it please?Thanks

riny_van_eekelen · Answer

JPMFly&nbsp;You'll find it under 'Apple logo', System Preferences..., Language and Region, Advanced, General.&nbsp;&nbsp;I'm still on Monterey, so it may look different if you are on a more modern MacOS

jpmfly · Answer

hello&nbsp;Riny_van_Eekelen&nbsp;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.&nbsp;I’m on SONOMA as I just bought my Mac two weeks ago.&nbsp;&nbsp;

Forum Discussion

Cannot find how to setup "." as the decimal symbol instead of ","

Share

Resources