Adding Indian Style Commas to numbers in MS Excel - Using Cutom Number Format

  Well, the better way to use Indian Style commas while working in MS Excel is to change the 'Region and Language' Setting of your Windows system. However, there is another work around in MS Excel to automatically add commas to number in Indian Style i.e. first comma at three digits and then the subsequent commas are at interval of 2 digits. For instance, 1,000,000 will appear as 10,00,000. This is particularly useful when you are working with currency in INR. 

 Steps to follow:

    1. Select the range which needs to be formatted. Let's take the following sample data which uses the default 1000 comma separator :

 

    2. Press Ctrl + 1. This will open the number format dialog box and then select Custom category shown below.

 

    3.    The add the this custom number format string [>1000000]"Rs" #\,##\,##\,##0"/-";[>=100000] "Rs "##\,##\,##0"/-";"Rs "##,##0"/-" into the 'Type Text Box' as shown below.