Excel 2007 : Currency symbol

Do you only want the currency symbol, or do you also want to add letters to indicate what kind of currency e.g. AUS$100? If the latter, I think you will need to set a custom number format.

in the Home tab, under cells, select format > format cells > custom

in the box, type "AUS"$0.00 (note the letters go in double quotation marks, the dollar symbol comes after)

press enter

this will create a new custom number format you can apply to all your Australian dollar values

NickyC

I appreciate your help but I want to replace Chinese and French symbol with AUD and NZD in number pane as attached. I think some change has to be done with accounting formats.

Thanks.

Did you try DILIPandey's suggestion - click "more accounting formats" and then the Symbol box - this gives you lots of options for currency formats.

I am working the way DILIPandey suggests, but it takes a lot more time to locate different currency symbol from box. My purpose is to make a shortcut. There is no chance to use Chinese/french symbol that's why I post to seek way to replace these symbols.

Thanks.

Thanks martindwilson!

I have created styles and now things are quite easy now.

I appreciate your help.

nlm.