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
iMac (24-inch, M1, 2021, 2 ports)
From what I've seen in other threads, your choice of region dictates what number separators 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
From what I've seen in other threads, your choice of region dictates what number separators 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
I can't find the "Number Format" dropdown. Can you please point out where it is exactly?
That is so strange because mine has it under the date...
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
The number format is only available for certain countries, South Africa being one of them. I went 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.
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. :(
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__
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
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.
No, I want to have it changed across my systems. Excel is just one of the applications where this is used.
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
...until the next update though that has "bug fixes", right???
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.
How to change the number separators
