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 has no affect over Excel.

 

Any thoughts?

 

Thanks

Excel on Mac
office 365
  • arsradu's avatar
    arsradu
    Copper Contributor
    Jun 04, 2024

    So I guess 2 years later there's still no way to change the default Currency to anything other than whatever's set in the Region settings. And with Apple removing the Advanced options from that, it's even harder to get this done.


    I wonder if it's not possible or Microsoft just didn't implement a way to overwrite that default regional setting from MacOS.
    Anyway, I'm disappointed. This should be an easy fix. But looks like nobody cares enough to actually implement it.

    • Typhoon007's avatar
      Typhoon007
      Copper Contributor
      Feb 16, 2022

      Thanks Riny_van_Eekelen 

      I restarted my Mac, and it seemed to have worked...

      But not as I intended... 

      I mean, the default currency changed to US $, but it appears as US$ on the Excel sheet:

      Under Format Cells, you can see that the Symbol changed from $ to US$:

       

      Below is a screenshot of the Language and Region Advanced settings:

       

       

      What do I need to change to make sure the default currency is $ and not US$?

       

      Thanks!

       

      • 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.

Resources