Excel 2007 : Adding new currency symbol

**nlm** · 12-09-2011, 03:54 AM

Hi,

I want to replace Chinese and Switzerland currency to AUD and NZD from the the number group under Home tab. Please see the attached image for clarification.

Thanks.

**dip11** · 12-09-2011, 06:55 AM

I think that is linked to your region settings. You need to change it there (Control Panel - Region and Language)

In terms of using AUD and NZD, if you click the little box with arrow next to "Number", you can manually select your currencies there for the cell and then fill format accordingly.

**nlm** · 12-09-2011, 08:00 AM

Dip11 you are correct, but I have an extensive use of these currencies and its cumbersome to select every time your way.

I appreciate your reply.

Thanks.

**dip11** · 12-09-2011, 08:12 AM

Outside of changing your region settings, I do not believe there is another way of getting them to show up like you want them to.
Strangely though, using the region settings you can only get either AUD or NZD, not both in the dropdown.

More information:
http://windows.microsoft.com/en-GB/w...d-measurements
So if you got administrator rights you could setup a custom locale there which would allow you to use both AUD and NZD in the dropdown.