Share via

How to format currency in Indian currency format

Pushkar Sen 0 Reputation points
2026-05-18T00:16:39.4633333+00:00

Indian currency is as follows 100,00,000.00 for $10,000,000.00.

Microsoft 365 and Office | Excel | For education | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rin-L 20,520 Reputation points Microsoft External Staff Moderator
    2026-05-18T13:47:40.59+00:00

    Hi @Pushkar Sen, 

    You can use a custom format in Excel to display numbers in the Indian currency style, and it works quite nicely once set up. 

    Just select the cells you want to format, press Ctrl + 1 to open the Format Cells window, then go to the Number tab and choose Custom. In the Type field, you can paste one of the following formats: 

    [>9999999]##,##,##,##0.00;[$₹][>99999]##,##,##0.00;[$₹]##,##0.00 

    or 

    [$₹][>9999999]##,##,##,##0.00;[$₹][>99999]##,##,##0.00;[$₹]##,##0.00

    User's image User's image

    Once you apply it, Excel will automatically format your numbers using the Indian numbering system, so values will appear with the correct grouping style. 

    Hope this helps make things a bit easier for you. 

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

    Was this answer helpful?

  2. AI answer

    2026-05-18T00:16:57.4566667+00:00

    Excel does not provide a built‑in Indian currency (lakhs/crores) grouping format in the referenced material. The available guidance covers applying standard Currency or Accounting formats only.

    To format numbers as currency with the options documented:

    1. Select the cells to format.
    2. On the Home tab, in the Number group, either:
      • Click Accounting Number Format to apply the default currency symbol, or
      • Press Ctrl+Shift+$ to apply the Currency format.
    3. For more control:
      • On the Home tab, select the Number Format launcher (small arrow) in the Number group, or press Ctrl+1.
      • In the Format Cells dialog, on the Number tab, choose Currency or Accounting.
      • In Symbol, choose the desired currency symbol (or None to show monetary values without a symbol).
      • Set Decimal places to the required number of decimals.
      • For Currency, choose how negative numbers should display. (Accounting always shows negatives in parentheses.)
      • Select OK.

    Currency vs. Accounting behavior (as documented):

    • Currency
      • Currency symbol appears next to the first digit in the cell.
      • Decimal places can be set; thousands separator can be turned on/off.
      • Negative numbers can be displayed in different styles.
    • Accounting
      • Currency symbols and decimal points are aligned in a column.
      • Zeros display as dashes.
      • Negative numbers display in parentheses; this default cannot be changed without a custom number format.

    For Excel for the web, the documented steps are:

    1. Select the cells.
    2. On Home → Number group → Number Format drop‑down, choose Currency or Accounting.
      • Currency: decimal points aligned; symbol next to first digit.
      • Accounting: currency symbols and decimal points aligned; zeros show as hyphens; negatives in parentheses.

    The referenced documentation does not describe an Indian‑style digit grouping (e.g., 1,00,000) option; it only covers standard Currency and Accounting formats.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.