Unofficial archive. This is a read-only, community-run archive of the Apple Support Community. It is not affiliated with or endorsed by Apple Inc.

Ventura change decimal separator ?!?!

Hello,


Where in the world did they put the way to change the coma into a dot (or vice versa) in Ventura ?!?


Before it was in System Preferences> Language & Region > Advanced> 


There is no "advanced" tab any more ?!?


Can someone help ?


Thank you

39 replies

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, same here. I live in Switzerland and my system is in French.


Why in the world would you hide the number format option depending on where you live ?!?!?


My workaround is to keep my system in French and force excel to run in English, then the coma is the decimal point !


Hope this will be fixed!

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.



In the financial environment in Switzerland the setting should be:

decimal separator = .

grouping separator = Space


It is impossible to achieve this with the options provided when "Schweiz" (= Switzerland) is chosen for the Region. I tried to use the workaround you proposed and started "Numbers" thereafter. Choosing "Zahl" (figure) with grouping separator active, Numbers did not do any grouping at all.

My preferred app (RagTime) applied the system settings after installation. Fortunately I was able to overwrite them by transferring RagTime's formatting preferences from an old computer, thereby curing the problem for me. But Apple should really go back to the version which allowed for all possible combinations as up to Monterey.

I am using English, but I had to change the region before seeing "Number Format". I didn't change the language, but that might help. ??

@stifou14

Many - if not all - users experience the same issue. It's a severe bug in Ventura. Please make sure to report it to Apple Feedback - macOS - Apple


MaximusAT wrote:

The Terminal workaround worked for me, but this is something absolutely crazy that can break thousands of excel files...how could Apple let this happen?!


FWIW, it will not break thousands of excel files, because excel is smart enough to store the data in a format that is independent of how numbers are displayed. It just so happens that they may not show the same way - and, of course, it matters when you enter new data into them.


That said, of course this needs to be fixed.

At the moment, I do see the option to change number format, but yesterday I am pretty sure it wasn't there... something is clearly wrong.

If you are a Keyboard Maestro user you can easily overcome this limitation by using the "Insert Date" action and changing the default formatting to:


%ICUDateTime%MM.dd.yy%


This will yield a date of:


12.02.22


Modify, if you wish, to make it a four-digit date along the lines of:


%ICUDateTime%MM.dd.yyyy%


Which will yield today's date as:


12.02.2022


You can change the separators to whatever you prefer; as you can see I prefer the dots instead of slashes.

cspkloof wrote:

How do you force Excel to run in English?


By default, applications (if coded properly) follow the system setting.


You can change the language for specific applications, though.


Go to System Settings->Language & Region.

At the bottom, you see "Applications". Click the + sign to add an application and select the language you want to use it with.

Thank you very much for the effective but partial tip.


It works for:

  • the DECIMAL separator where you can input a dot
  • but for the THOUSANDS separator, it doesn't let me put anything (I wanted a comma) :(


Does it let you?


Does anyone know how to use the Terminal workaround to set the grouping separator to a space? The obvious solution

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

produces the error "defaults[83767:7029208] Unexpected argument .; leaving defaults unchanged."

Vollschaaf wrote:

The obvious solution
defaults write .GlobalPreferences AppleICUNumberSymbols -dict 0 "." 1 " " 10 "." 17 " "
produces the error "defaults[83767:7029208] Unexpected argument .; leaving defaults unchanged."


I wonder if space in that command needs to be encoded somehow, like "\ "

' and " marks are in general interchangeable with some exceptions (depending on what you quote), no difference in this particular case.


but regardless - the Language & Region settings should not become disabled regardless of what you send via Terminal (even if it's total gibberish). it's a serious bug in Ventura.

leobraun wrote:

the Language & Region settings should not become disabled regardless of what you send via Terminal (even if it's total gibberish). it's a serious bug in Ventura.

Indeed. I wonder if anyone else has run into this.

Berthet Jean-François I tried but I cant access anymore to System > General > Language & Region.

Seems like this broke my ventura, other settings just opened fine.


Is there a way to revert to original ?


Thanks!

This workaround worked in order to change the decimal point of my Mac OS (Portuguese) from comma to dot. But the group separator is the aposthrofe ('). I tried to change the group separator to comma (,) with


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


but it didn't work. Does anyone know how to change the to the following number format: 10,000.00, as it was before the latest Ventura update?

My computer is in French and I do not have the "format number" option... it is just not there!


What language are you on ?

unfortunate I had to use sheets from google

It still does not give "space" as a separator option if I choose "." to indicate decimals.


😒

-g and .GlobalPreferences is the same thing. i just copied my command originally from a different source.

What about the quote marks? Don’t matter?

Yes I just did after reading this thread. language and region won't open anymore after doing the command line mentioned earlier.

Same for me. Regional Settings won't open. I tried to revert changes with no luck. What a shame.

Be sure to let Apple know via


http://www.apple.com/feedback


Done!

Thank you, Jean-Francois,


I changed the format back to decimal comma and space for the thousands, but I would prefer to use halve space as used by the Système Internationale and actually also official in Germany and other European countries.