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.

How to change the number separators

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

13 replies

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

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 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.


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__


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.  

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. :(

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

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...

...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.