Changing default currency in Excel on a Mac

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3168249%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EChanging%20default%20currency%20in%20Excel%20on%20a%20Mac%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3168249%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI've%20found%20a%20few%20articles%20on%20changing%20Excel's%20default%20currency%20on%20Windows%2C%20but%20couldn't%20find%20a%20way%20to%20do%20so%20on%20a%20Mac.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20did%20change%20the%20system-wide%20settings%20under%20%22Language%20and%20Region%22%2C%20but%20it%20has%20no%20affect%20over%20Excel.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EAny%20thoughts%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThanks%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3168249%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EOffice%20365%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

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

6 Replies

@Typhoon007 Be sure that you close Excel and restart it. Then it should work.

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:

Typhoon007_2-1645023994604.png

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

 

Typhoon007_1-1645023980870.png

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

 

Typhoon007_0-1645021777781.png

 

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

 

Thanks!

 

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

Screenshot 2022-02-16 at 16.14.50.png

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.

Thanks @Riny_van_Eekelen

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

Typhoon007_1-1645026270273.png

 

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

Typhoon007_2-1645026328913.png

 

Typhoon007_0-1645026211884.png

 

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

 

 

@Typhoon007 Sorry, don't know!

Thanks @Riny_van_Eekelen for trying!
Maybe somebody else found a workaround