To show Indian rupees in Excel for Microsoft 365 on Windows, select the cells, press Ctrl+1, choose Number > Custom, and enter "₹" #,##,##0.00. The format displays values with the ₹ symbol, Indian comma grouping, and two decimal places—for example, 1234567.89 appears as ₹ 12,34,567.89.
How Indian rupee formatting works
Excel stores a number as a value and applies a number format to control how that value looks in a cell. A rupee format does not convert dollars, paise, or any other unit into rupees; it adds a visual label and chooses how to display the existing number. If a cell contains 1234567.89, the custom format above shows it as ₹ 12,34,567.89, while the underlying value remains 1234567.89.
Indian number grouping differs from the familiar Western pattern. The first comma is placed after the last three digits to the left of the decimal point; further groups are two digits wide. Thus, 1,234,567 is written 12,34,567, and 10,000,000 is written 1,00,00,000. In Indian terms, these correspond to twelve lakh thirty-four thousand five hundred sixty-seven and one crore. The commas improve readability; they do not change the number or its meaning.
In a custom format, the zero placeholders and comma positions define the display. The quoted text "₹" prints the rupee sign literally, while #,##,##0.00 displays the number with Indian grouping and two decimal places. Quoting the symbol makes clear that it is text to show, not a formatting instruction.
Apply a custom rupee format in Excel
- Select the cells, column, or range you want to format. To format an entire column, select its column heading.
- Press Ctrl+1 to open Format Cells. Alternatively, use the dialog box launcher in the Home tab’s Number group.
- On the Number tab, choose Custom in the category list.
- Click the Type box, enter
"₹" #,##,##0.00, and select OK.
Check a few values after applying the format, especially a number with more than six digits and one with a decimal part. If the rupee sign appears as a box or question mark, the font or display environment may not support the character. Try a common Unicode-capable font such as Aptos or Arial, or check that the symbol was entered correctly. On Excel for Mac, Command+1 opens Format Cells; the custom-format approach is similar, though the dialog layout can differ. Excel for the web may not expose the full custom-format controls in every interface, so use desktop Excel to create or edit a complex custom format if needed.
Choose the number of decimal places
For amounts that include paise, two decimal places are often useful. The two zeroes after the decimal point in #,##,##0.00 mean Excel always displays two digits: 45 appears as 45.00, and 45.6 appears as 45.60. This is a display choice, not a claim that the underlying value has changed.
If your report uses whole rupees, use "₹" #,##,##0. A value such as 1234567.89 will then appear without decimal places, as ₹ 12,34,568, because Excel rounds the displayed value to the nearest whole number. The actual cell value is still unchanged. If you want decimals only when they are present, try "₹" #,##,##0.##; the optional decimal placeholders can hide trailing zeroes. For example, a value of 45.6 can display as ₹ 45.6, while 45 can display without a decimal point.
Pick a consistent convention for a whole worksheet or report. Showing two decimals in some rows and none in others can make amounts harder to compare, even when all the stored values are numeric. For invoices, budgets, and summaries, use the precision that matches the source data and the purpose of the report.
Useful custom format examples
Enter one of these codes in the Type box under Format Cells > Number > Custom. Select the cells first; a custom format applies to the selected cells.
"₹" #,##,##0.00displays two decimal places, such as ₹ 12,34,567.89."₹" #,##,##0displays whole rupees, such as ₹ 12,34,568 for a stored value of 1234567.89."₹" #,##,##0.##displays up to two decimal places without forcing trailing zeroes."₹" #,##,##0.00;[Red]("₹" #,##,##0.00);"-";@shows positive numbers normally, negative numbers in red parentheses, zero as a dash, and text as entered.
Custom formats can have up to four sections separated by semicolons: positive values, negative values, zero values, and text. In the last example, [Red] sets the negative number’s font color, parentheses make the negative sign easier to spot, "-" substitutes a dash for zero, and @ displays text. This changes presentation only; it does not turn a negative amount into a positive one or replace zero in the cell.
Negative amounts, zeroes, and accounting layouts
A simple format such as "₹" #,##,##0.00 is enough for many lists. Excel will still show negative values as negative, usually with a minus sign, but the exact appearance can depend on the format and regional settings. A custom format with separate positive and negative sections lets you choose a consistent style. Parentheses, for instance, make a negative balance visually distinct without changing the value.
You can also choose how zeroes appear. Leaving zero as 0.00 is explicit, while showing a dash can make a large report less cluttered. Be aware that a dash may be mistaken for missing data. If readers need to distinguish a true zero from a blank cell, explain the convention in a note or keep zero visible.
For financial statements where currency symbols should line up vertically, consider Excel’s built-in Accounting format. Select the cells, open the Home tab, and use the number-format list in the Number group. The available symbol and grouping depend on Excel’s region and language settings. A custom format is more direct when you specifically need Indian grouping and the ₹ symbol, though it will not align symbols in the same way as an Accounting layout.
Formatting is not the same as converting data
Applying a rupee number format does not attach a currency unit to the stored value in a way that another system can reliably interpret. Excel still treats the cell as a number, which is useful: you can add, sort, average, and chart it normally. But if a column mixes rupees with values in another currency, formatting every row with ₹ can mislead readers. Keep currencies separate or clearly identify the unit for each row.
Do not type the rupee symbol into every value as ordinary text if you need to calculate with the amounts. For example, an entry such as “₹ 1,000” pasted or typed as text may not behave like the numeric value 1000 in formulas and sorting. Prefer entering the number alone and applying the format. If imported data already contains symbols and commas as text, clean or convert it to numeric values before relying on calculations; changing the number format alone will not convert text into numbers.
Also distinguish formatting from rounding. A cell displayed with no decimal places may look rounded, but its stored value can retain decimals, and formulas use that stored value. If a calculation must use a rounded amount, rounding has to be part of the calculation or the data itself—not merely a display format.
Common problems and how to fix them
- Commas appear in Western groups. Confirm that the custom code uses
#,##,##0, not#,##0. The latter is the common three-digit grouping pattern. - The rupee sign is missing or looks wrong. Re-enter the ₹ character inside quotation marks in the custom format. If the font shows a blank box, try a font that supports the symbol.
- The format is rejected or looks different. Regional settings can affect the characters Excel uses for decimal and list separators. Check the separator conventions in your Excel installation and adjust the code accordingly.
- Values do not calculate. The cells may contain text rather than numbers. A number format changes the appearance of numeric cells; it does not repair text imported with currency symbols or separators.
- Only some cells change. Check that the intended range was selected and that the cells do not have a different format applied afterward by a table style or another formatting action.
When checking a custom format, test both a small amount and a large amount. For example, 1000 should display as ₹ 1,000.00 and 1234567.89 as ₹ 12,34,567.89. Testing only a small value may not reveal that the grouping pattern is wrong.
Custom format or built-in currency format?
Use a built-in currency or accounting format when Excel already offers the correct rupee symbol, grouping, and decimal behavior for your region. It is quick to apply and easy for other spreadsheet users to recognize. However, available symbols and defaults can differ between computers, so the same built-in selection may not give every recipient the exact appearance you expect.
Use a custom format when a workbook needs a specific Indian grouping pattern, a fixed number of decimals, a chosen negative style, or a dash for zero. Custom formats are stored in the workbook, but the rupee character still needs to display correctly in the recipient’s environment. For a shared workbook, include a clear column heading such as “Amount (₹)” as well as the cell formatting. The heading provides context if someone views the data in software that does not preserve the formatting.
Frequently Asked Questions
How do I format Excel cells in Indian rupees?
Select the cells, press Ctrl+1, choose Number > Custom, and enter "₹" #,##,##0.00. Choose the number of decimal places that suits your data, then select OK.
What is the Excel format for lakhs and crores?
For Indian digit grouping, use #,##,##0 for whole numbers or #,##,##0.00 for two decimals. With a rupee symbol, use "₹" #,##,##0.00. A value of 10000000 then displays as ₹ 1,00,00,000.00.
How do I show the ₹ symbol without changing the number?
Apply a custom number format containing the symbol, such as "₹" #,##,##0.00. Excel keeps the cell numeric; the symbol is only part of its displayed format.
Why does Excel show commas in the wrong places?
The format may use a Western grouping code such as #,##0, or regional settings may affect how the code is interpreted. Use the Indian pattern #,##,##0 and check the decimal and grouping separators used by your Excel installation.
Does formatting a number as ₹ convert it to rupees?
No. It only changes how the value looks. Confirm that the underlying amount is already denominated in rupees; a number format cannot perform currency conversion.
Related
- Excel Save As Keyboard Shortcut: F12 and Mac Options
- Excel Invoice Template: Find Free Microsoft Options
- Excel Interpolation: How to Estimate Values Between Points
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Edit Mail Merge Fields in Word Documents Step by StepTo edit a mail merge field in Word, select it in your document and use the Mailings tab…
- How to Make a Flowchart in Microsoft Word, Step by StepTo make a flowchart in Microsoft Word, open a document, choose Insert > Shapes, add flowchart shapes for…
- Excel Data Table Sensitivity Analysis ExplainedExcel data table sensitivity analysis shows how changing one or two input values affects a formula’s result. In…
- Excel Columns Keep Collapsing? Causes and FixesIf Excel columns keep collapsing, they are usually hidden or grouped into an outline—not deleted. On Windows, select…
- How to Add a Watermark in Word 365, Text or PictureTo add a watermark in Word 365 on Windows, open the document and choose Design > Watermark, then…
- Google Sheets IF Function: Syntax and ExamplesIn Google Sheets, the IF function checks whether a condition is true and returns one value if it…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.