Forum Discussion

Sylvia1404's avatar
Sylvia1404
Copper Contributor
Apr 01, 2023

Excel on Mac Ventura 13.3 1000 separator stopped working

My Excel stopped working using the 1000 separator.  I think it has something to do with the region.  I have done changes, yet noting works. Can anyone offer a solution? As it is now I am not able t...
Charting
excel
Excel on Mac
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Apr 01, 2023

Sylvia1404 

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! 

 

  • Sylvia1404's avatar
    Sylvia1404
    Copper Contributor
    Apr 02, 2023

    NikolinoDE 

     

    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

     

     

    • NikolinoDE's avatar
      NikolinoDE
      Platinum Contributor
      Apr 02, 2023
      I am pleased that you have found a solution to your problem and thank you for the feedback.

      I wish you continued success with Excel.