I want to change number separators, for decimal to be a comma, and thousand separators to be a dot.
This setting was under the advanced tab of Language and Region in MacOS Monterey.
I am unable to find this setting in MacOS Ventura
I want to change number separators, for decimal to be a comma, and thousand separators to be a dot.
This setting was under the advanced tab of Language and Region in MacOS Monterey.
I am unable to find this setting in MacOS Ventura
Posted on Oct 25, 2022 7:35 AM
Oct 31, 2022 11:35 AM
From what I've seen in other threads, your choice of region dictates what number separato 0000322C rs you have, and if you get the option or not.
As yours is set to United Kingdom, try changing to another (such as South Africa, the region Lizzy has it set to) and seeing if it pops up. My guess is that it will- but even if you change the setting, your changes won't persist when you switch your region back.
At any rate, you can submit feedback here - Feedback - macOS - Apple
Oct 31, 2022 6:45 AM
Hi, open System Preferences, General, Language & Region, Number Format. It has a dropdown of two possible formats:
$1,234,567.00
$1 234 567,00
Oct 31, 2022 11:42 AM
The number format is only available for certain countries, South Africa being one of them. I w 00004000 ent thru a number of countries in Europe and found one or two with the number format. Great Britain was not one of them. Neither is the US. So we're stuck with the default for that country.
Oct 31, 2022 11:29 PM
Thanks Lizzy
It is helpful to see that if I change the region to South Africa, I would be able to use the alternate separators. However, I am still getting spaces for the thousand separators and not the period sign. It is still better than using a different convention altogether.
If the region is selected to India I don't get the options. I tried USA and UK, and Germany, France, but the options didn't pop up.
I have submitted this as feedback for feature request to apple, as pointed out by __Bubba__
Oct 31, 2022 1:40 PM
I'm not sure it's a bug or intended. In any case Tell Apple what missing features you'd like restored or new features added to the system via Feedback - macOS - Apple.
Oct 31, 2022 1:25 PM
This is a major problem for me, so much so that I am willing to downgrade back to Monterey because I work with spreadsheets all day and if the numbers are in the wrong format (anything other than "$1 234 567.89" Then this is a problem for me... My brain cannot cope with that. :(
Oct 25, 2022 8:27 AM
Judging from this post, it seems like you want to change the separators in Excel. See below-
Change the character used to separate thousands or decimals in Excel - Microsoft Support
Oct 25, 2022 8:31 AM
No, I want to have it changed across my systems. Excel is just one of the applications where this is used.
Oct 25, 2022 9:19 PM
This Microsoft feature is good for Windows systems. Not Apple. There's no "Options Menu under File" and no Advanced tab under Preferences. I am using Excel v 16.66
Oct 31, 2022 7:34 AM
I can't find the "Number Format" dropdown. Can you please point out where it is exactly?
Oct 31, 2022 11:31 AM
That is so strange because mine has it under the date...
Oct 31, 2022 1:09 PM
...until the next update though that has "bug fixes", right???
Oct 31, 2022 1:23 PM
Lizzy.vanwyk wrote:
...until the next update though that has "bug fixes", right???
Perhaps, perhaps not. It's up to Apple whether or not they want to re-add that feature for all regions.
Originally posted at discussions.apple.com/thread/254316314