How to Show Indian Currency Format in Excel?

 

How to Show Indian Currency Format in Excel
In this post I will show you how to display US dollar format to Indian currency format in Microsoft Excel. i.e Comma separator for custom Currency (Indian Rupee). The numbers are generally grouped in US format as shown below,

  1. US Dollar Format Grouping: 86,987,324.00
  2. Indian Rupees Format Grouping: 8,69,87,324.00

Steps to Show Indian Currency Format in Excel

  • Goto the Control panel and select the “Region and Language” button
  • Select “Additional Settings”
  • Set digit groupings to the Indian grouping as shown below,
Indian Currency Format in ExcelIndian Currency Format in Excel
  • Do the same on the “Currency Tab” and Apply.
  • Now in Excel the Default “,” and “$” Style will show the way you wanted.

That’s it :) Excel currency format and comma separator problem is fixed.

Subscribe to receive more Adsense, SEO,Blog Hacks articles to your Inbox

Share this Post:
Digg Google Bookmarks reddit Mixx StumbleUpon Technorati Yahoo! Buzz DesignFloat Delicious BlinkList Furl

One Response to “How to Show Indian Currency Format in Excel?”

commenter

It’s nearly impossible to find knowledgeable people on this subject, however, you seem like you know what you’re talking about! Thanks

Leave a Reply:

Name (required):
Mail (will not be published) (required):
Website:
Comment (required):
XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>