How to make Excel show numbers in Indian Format

 

This could be an interesting piece of information if you are someone who uses excel for financial analysis or if you play with big numbers in excel sheet.

By default, Excel groups a number in English style, ie., Twelve Lakhs will be shown as 1,200,000 , where in we Indians are more used to depict it as 12,00,000.

So how to make excel format numbers in Indian Style by default.

Go to control Panel and Select Regional and Language Options and then go to Additional Settings ( If you are a Windows 7 user) or go to Regional and Language Options and Select Customize ( if you are Windows XP User ) and change the number grouping formats.

Control Panel –> Regional and Language Options –> Customize

See the Screen Shots below for easy understanding

  

This is obviously not a big trick, but it will surely make the person who looks at your excel sheet, feel more comfortable

In the same Customize Regional Options window,  you can also set the default Currency Symbol, for instance say I want “Rs.” as a default, I would type Rs in the Currency Symbol Box. 

Happy Spread Sheeting ;)

Technorati Tags: excel,format,number,india,lakhs,millions,english,regoinal,language