Forum Discussion

LocalMocean's avatar
LocalMocean
Copper Contributor
Nov 12, 2021

Number Format

Good Day,

 

I am located in the US Virgin Islands and I have a Macbook Pro with MacOS operating system.  I have Microsoft 365 and excel version 14.68.  I have been trying to get my numbers in the correct US format but I can’t figure out how to get the decimals and commas switched around. 

 

Formulas and Functions

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Nov 12, 2021

    LocalMocean Press the Apple logo (top left), System Preferences..., Language & Region. Choose your region here and it should probably work correctly right away. If not, press Advanced and change the settings in the next screen.