Hi,
I updated to Ventura and can't find where to simply write specify what I want to use as thousand separator and decimal separator. Previously you could go in under System Settings > Language Region and type in to have ' for the thousands and a . for the decimal. Now it seems I can only choose predetermined options that do not work for me at all. Where do I go to customise this?
Thank you for your help!
/Fred
Hi SG,
Thanks for your reply. It's what I've been doing before, but now it would seem you can't choose a custom combination. Let's say for example that I want to use an apostrophe ' as the thousands separator and a dot . as the decimal separator. This kind of customisation was doable in previous MacOS but seems to have been removed and replaced by some arbitrary format based on countries? If you can tell me how to get the combo mentioned in the example above I'd be very thankful.
Basically I want Numbers to recognise 1'234'567.89 as a number for my formulas.
These formats are the ones I can choose from in my country/region and I can't seem to find the "customise" option...
Hi SG,
Thanks for your reply. It's what I've been doing before, but now it would seem you can't choose a custom combination. Let's say for example that I want to use an apostrophe ' as the thousands separator and a dot . as the decimal separator. This kind of customisation was doable in previous MacOS but seems to have been removed and replaced by some arbitrary format based on countries? If you can tell me how to get the combo mentioned in the example above I'd be very thankful.
Basically I want Numbers to recognise 1'234'567.89 as a number for my formulas.
These formats are the ones I can choose from in my country/region and I can't seem to find the "customise" option...
Fredheg wrote:
I want Numbers to recognise 1'234'567.89 as a number for my formulas.
Probably missing something, but I easily got that format in Ventura 13.1 without going to the terminal or worrying about fashioning a custom number format.
It was just a matter of picking the region / language combination that provides the desired number format (and the language) I want to use.
Here it is at the document level at File > Advanced ... in Numbers 12.2.1.
Similar at the system level in Systems Settings in macOS Ventura 13.1. Lots of built-in options (I think over 100 different regions) with seemingly every conceivable number format already there.
SG
HPhil84 wrote:
Hi, that's a solution for Numbers but with Excel version 16.69.1 that doesn't work. There is still a problem with the Swiss-French language in the region settings.
Does this help?
Customizing Number Format in Ventura - Apple Community
There's also a forum for Excel at
You can go to System Settings > Language & Region and choose a region that uses the thousands and decimal separators that you want.
You can also do this on a document-specific basis (i.e., have different settings for different documents) within Numbers. File > Advanced > Language & Region ...
SG
Thank you!!
Hi, that's a solution for Numbers but with Excel version 16.69.1 that doesn't work. There is still a problem with the Swiss-French language in the region settings.
Numbers - how to customize Number format
