Show Indian Currency Format in Excel – Learn

Learn to show Indian Currency Format in Excel
(On request of Mr. Ksan Warjri)

Indian numbers are grouped differently than standard English numbers. Learn to format numbers and amounts in Indian currency and number formats.

English Grouping : 123,456,789.01

Indian Grouping : 12,34,56,789.01

===============================
Quick and easy fix to show numbers in Indian format
=================================

1) Enter the desired number in a Cell (A1)
2) Right clink on the Cell (A1)
3) Select “Format Cells”
4) Select “Custom” from Left side Category list
5) Copy below given custom format paste in “Type” fields
6) Click on “OK”

Custom number formats:

[>=10000000]##,##,##,##0;[>=100000] ##,##,##0;##,##0

or

[>=10000000]”RS “##,##,##,##0;[>=100000]”RS ” ##,##,##0;”RS “##,##0

===============================
A permanent solution to Indian Number Formats
===============================

However there is better and more permanent solution using the Systems Regional Settings

1) Go to the Control panel and select the “Region and Language” button
2) Select “Additional Settings”
3) Set digit groupings to the Indian grouping like this: 12,34,56,789
4) Indian Currency Formatting, Number Formatting – Settings in Control Panel
5) Do the same on the Currency Tab and Apply

Now in Excel the Default “,” and “$” Style will show the way you wanted.