Numbers in Indian currency format

{9 Comments}

To display numbers in Indian currency format, use the following custom number format

[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00

RSS 9 Comments…

 Share your views
  1. Hi,

    How to get the same Indian currency format for negative numbers?

    Regards,
    Suresh

  2. Hi,

    I am using Excel 2010. The format changes to millions for negative numbers.

    Regards,
    Suresh

    • Hi,

      The solution I posted was for versions of Windows prior to Windows 7. From Windows 7 onwards, if you set the Regional settings (Control Panel > Regional Settings) to India, the number format should show up in the Indian number format.

  3. Hi,

    I am working outside India. So, I dont want to change the regional settings to India.
    But I want to use the Indian currency format for India branch reports. Possible?

    I am currently using Windows 7 and Excel 2010.

    Regards,
    Suresh

    • Hi,

      Try this

      1. Select any numeric cell (say cell C5) in your file and go to Home > Conditional formatting > New Rule > Use a formula to determine which cells to format
      2. In the formula bar there, enter =C5<0 and click on Format
      3. On the Number tab, go to Custom > Type
      4. Paste this string there [< =-10000000]##\,##\,##\,##0.00;[<=-100000]##\,##\,##0.00;##,##0.00 5. Click on OK/Apply 6. Copy this cell and Paste Special Formats to all numeric cells The process above is for applying India currency format to negative numbers in your range. For positive numbers, follow all steps above. In step 4, change the string to [>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00

      Hope this helps.

      • Hi,

        For positive and negative numbers no change in the display. Both cases displayed as positive in Indian currency format.

        Regards,
        Suresh

  4. this format is for the numbers till 1 crore. if i want to add more commas, say for 100 crore, what is the formula for that?

Leave a Comment

Your email address will not be published.

*

*