Insert currency symbol in excel cell

[tkraju]

A	B	C	D	E
Australian Dollar	Indian Rupee	Singapore Dollar	United States Dollar
AUD 100.00	INR 55.00	SGD 15.00	USD 200.00

How to prefix currency symbol if enter a numerical(number) in row 2 of my w/sheet. I need results as above. If I enter number 100 in cell A2 it should display number with currency symbol as AUD 100.00. Any formula or Conditional format ?

 

[DRSteele]

Format each column's cells with a Currency Number Format. Scroll down the list about halfway and you will see abbreviations for each currency rather than the typical currency symbol.

Canada, Australia, New Zealand, USA ... all use the dollar-sign symbol, which presents the problem you're having. [And if you want to know why they all use the dollar-sign, review this Wikipedia article.]