Forum Discussion
Excel on Mac Ventura 13.3 1000 separator stopped working
As far as I could research on the internet, one solution proposal that might work for you is to adjust the regional settings in your Mac OS X International system preferences. Excel uses the Mac OS system separator for thousands, so you can specify a different system separator by changing these settings.
Another solution proposal is to select the cells that you want to adjust, then on the Home tab, under Number, click Display the value of a cell with a thousands separator.
I hope this helps!
- Sylvia1404Apr 02, 2023Copper Contributor
Good morning
I checked my home computer and the correct selection for the 1000 decimal separator was incorrectly selected on my work computer. It should be as follows: 1,234,567.89
I was using 1 234,567.89 which was not allowing the numbers to calculate.
Thanks
Have a great week
- NikolinoDEApr 02, 2023Platinum ContributorI am pleased that you have found a solution to your problem and thank you for the feedback.
I wish you continued success with Excel.