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
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
Posted on Oct 27, 2022 11:59 AM
Oct 31, 2022 11:08 AM
Same here. Switzerland with French.
A workaround:
defaults write .GlobalPreferences AppleICUNumberSymbols -dict 0 "." 1 "'" 10 "." 17 "'"
In this example:
decimal separator = .
grouping separator = '
Jan 31, 2023 5:45 AM
On Ventura 13.2, Settings > General > Language & Region : {Region, Number format}
Oct 27, 2022 1:18 PM
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…
Nov 7, 2022 7:38 AM
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:
For me the clean solution, no more messing around with language settings or command line solutions (even though quite cool).
Nov 6, 2022 5:36 PM
defaults write .GlobalPreferences AppleICUNumberSymbols -dict 0 "." 1 "'" 10 "." 17 "'"
It works for me. Thanks!!!
Dec 6, 2022 2:25 AM
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
Nov 6, 2022 12:13 AM
System Preferences> Language & Region> Region> Vietnam or Region similar
Nov 4, 2022 6:05 PM
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.
Feb 10, 2023 12:56 PM
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:
Mar 1, 2023 4:01 AM
(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.
Oct 29, 2022 10:04 AM
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!
Dec 18, 2022 6:16 AM
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.
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...
Mar 13, 2023 12:23 PM
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).
Oct 29, 2022 2:29 AM
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.
Feb 17, 2023 5:04 PM
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.
Mar 16, 2023 5:49 AM
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.
Oct 28, 2022 8:52 AM
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. ??
Feb 17, 2023 5:26 PM
Tne command you mention is somewhat different than the one here
Customizing Number Format in Ventura - Apple Community
but I don't know how much difference it makes
Mar 10, 2023 10:09 AM
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
Nov 2, 2022 3:56 AM
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.
Dec 2, 2022 9:49 AM
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.
Dec 5, 2022 11:04 PM
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.
Jan 24, 2023 7:07 AM
Thank you very much for the effective but partial tip.
It works for:
Does it let you?
Jan 31, 2023 5:27 AM
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."
Jan 31, 2023 7:17 AM
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 "\ "
Feb 17, 2023 6:03 PM
' 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.
Feb 17, 2023 8:20 PM
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.
Mar 10, 2023 7:49 AM
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!
Apr 2, 2023 2:54 PM
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?
Oct 27, 2022 9:54 PM
My computer is in French and I do not have the "format number" option... it is just not there!
What language are you on ?
Feb 5, 2023 7:07 PM
unfortunate I had to use sheets from google
Feb 16, 2023 5:38 AM
It still does not give "space" as a separator option if I choose "." to indicate decimals.
😒
Feb 17, 2023 5:35 PM
-g and .GlobalPreferences is the same thing. i just copied my command originally from a different source.
Feb 17, 2023 5:41 PM
What about the quote marks? Don’t matter?
Feb 26, 2023 6:21 PM
Yes I just did after reading this thread. language and region won't open anymore after doing the command line mentioned earlier.
Feb 28, 2023 4:44 PM
Same for me. Regional Settings won't open. I tried to revert changes with no luck. What a shame.
Mar 1, 2023 5:03 AM
Be sure to let Apple know via
http://www.apple.com/feedback
Mar 1, 2023 12:36 PM
Done!
Dec 16, 2022 7:00 AM
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.
Originally posted at discussions.apple.com/thread/254323655