Showing posts with label Excel Currency Format. Show all posts
Showing posts with label Excel Currency Format. Show all posts

Monday, March 8, 2010

Format Numbers : Excel Currency Format

You can add currency symbol to your numbers in excel.

Open Number Format dialog box using Format Cells option or just press Ctrl+1

1. Click Accounting
2. Choose currency symbol from drop down

Format Numbers : Excel Currency Format


In case you do not get your currency symbol from drop down, add your symbol using custom formating option in the same dialogbox
1. Click Custom
2. Type - "Rs "#,##0_);[Red]("Rs "#,##0)

I use "Rs " to show numbers in Indian Currency. You can replace it with your symblol.

Format Numbers : Excel Currency Format