Ventura change decimal separator ?!?!

Same here. Switzerland with French.

A workaround:

defaults write .GlobalPreferences AppleICUNumberSymbols -dict 0 "." 1 "'" 10 "." 17 "'"

In this example:

decimal separator = .

grouping separator = '

On Ventura 13.2, Settings > General > Language & Region : {Region, Number format}

It looks like it's called "Number Format" now, in General > Language & Region.

It appeared after I changed Region, and it stayed visible after switching back to my original region. I'm not sure if this is expected behavior…

Just had the same problem - didn't think the answers here are the best solution for me so I searched by myself: Now Excel has the option to define the decimal separator and the thousands separator. Just do that:

1. Go to Preferences (under Excel or with ⌘ , )
2. Click on 'Edit'.
3. Choose your preferred decimal separator (does it then automatically for the whole document)

For me the clean solution, no more messing around with language settings or command line solutions (even though quite cool).

defaults write .GlobalPreferences AppleICUNumberSymbols -dict 0 "." 1 "'" 10 "." 17 "'"

It works for me. Thanks!!!

defaults write .GlobalPreferences AppleICUNumberSymbols -dict 0 "." 1 " " 10 "." 17 " "

Replace ' with a space between the " ", worked for me to get this format 1 344 445.05



System Preferences> Language & Region> Region> Vietnam or Region similar

I had to add Numbers to the applications exception list at the bottom & then choose a different country for that app that would give me decimal points instead of commas. My system is normally on French (Canada) so I added English (UK) for Numbers.

Go to "General" -> "Language and Region". You will be allowed to select your favorite language and below that you can select the Region. In my case I have Italian as my favorite language, but the Region (Zona) is set to United States. If you set your Region to United States, it will give you an option for the numbers format to choose the decimal separator that you prefer, see the screenshot below:

(With Ventura 13.2.1) In Spanish of Spain, I want to put decimals with . and thousands with a small space, that is the recommendation of the Real Academia Española, and it is impossible; it is not an allowed preference in the menu. However, it is possible to do it with Spanish of Mexico. It is ridiculous. Apple, fix it!!!!!!

If you change it by hand using terminal or editing the ~/Library/Preferences/.GlobalPreferences.plist file, the preference menu does not understand it and fails.

Yes that's a serious drawback of Ventura! You can still contact Apple Support and make sure they file a feedbacks, do it directly using the link below and filling one using Feedback Assistant if you can.

Feedback - macOS - Apple

If enough people file something, maybe it will get to the engineer's attention, even though we should not have to do this in the first place for such a major serious issue to being addressed...

It is clear that it is a bug of Ventura.

Once that you have changed the preferences via Terminal, you cannot access any more to System > General > Language & Region.

At least in Ventura 13.2.0, a way to access again to System > General > Language & Region is to remove this file:

~/Library/Preferences/.GlobalPreferences.plist

(but then you must put your preferences again, of course).

I'm in the Netherlands. I tried this trick. I switched region go America->Canada. That gave me the option to change the number format, but when I returned the region to The Netherlands, the number format disappeared. So this is not the proper solution. My primary language is Dutch.

Be careful with the Terminal command!

After sending a custom formatting command on macOS 13.2, the Language & Region settings became disabled: it can't be open anymore (clicking on the Language & Region button doesn't do anything).

I sent this command (as I wanted dot for decimal and nothing for grouping, which setting is missing on Ventura):

defaults write -g AppleICUNumberSymbols -dict 0 '.' 1 '' 10 '.' 17 ''

Like I mentioned, it disabled the Language & Region settings (and didn't change the numbers format in the system anyway).

Sending other commands after this with different formats didn't make a difference.