Forum Discussion

Typhoon007's avatar
Typhoon007
Copper Contributor
Feb 15, 2022

Changing default currency in Excel on a Mac

Hi, I've found a few articles on changing Excel's default currency on Windows, but couldn't find a way to do so on a Mac. I did change the system-wide settings under "Language and Region", but it h...
Excel on Mac
office 365
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 16, 2022

Typhoon007 I see, but can't you select the $ English (United States) option in the Number format group on the Home ribbon? That one just produces the $ sign. Don't think you can change the default to anything other than what's in the list under Language&Region, Advanced.

I guess that the "US" prefix is defaulted as there are many currencies in the world that use the $ sign. Good to know which dollar you are talking about.

Typhoon007's avatar
Typhoon007
Copper Contributor
Feb 16, 2022

Thanks Riny_van_Eekelen. 

Yes, I could change that through the Format Cells (reached through by clicking the "More Number Formats").

 

There I had to scroll by to find the right "version" of the Dollar (as seen below)

 

 

The whole purpose of changing the default currency was to that all I needed to do when selecting a currency would be to click "Currency" from the format cell drop down.

Now I'm forced to go through 3-4 clicks just to achieve that...

 

Any other thoughts?

 

Cheers