Spreadsheets

Show the rupee symbol (₹) in Excel and Google Sheets

Show the rupee symbol in Excel and Google Sheets with currency formats, keyboard shortcuts and UNICHAR, and fix the empty box some fonts show.

Editorial illustration for Show the rupee symbol (₹) in Excel and Google Sheets

The quickest way to show the rupee symbol in Excel is to select the cells, press Ctrl+1, choose Currency and pick the rupee symbol from the Symbol list. In Google Sheets, use Format, Number, then a Custom currency and search for INR. Both keep the cell as a number you can still add up.

How do I format cells as rupees in Excel?

  1. Select the amount cells and press Ctrl+1.
  2. On the Number tab choose Currency (or Accounting, which lines the symbols up in a column).
  3. In Symbol, choose the rupee entry. It may be labelled English (India).
  4. Set two decimals if you want paise to show, then press OK.

If the rupee is missing from your list, choose Custom and type [$₹-4009] #,##0.00 in the Type box. That ties the symbol to the English (India) locale code, and keeps the cell numeric.

How do I type the symbol?

  • With the English (India) keyboard layout added in Windows, hold Right Alt (AltGr) and press 4. On many laptops that is Ctrl+Alt+4.
  • Windows key plus full stop opens the emoji panel, where the symbol tab has the rupee sign.
  • Alt plus 8377 on the numeric keypad works in some programs; it does not on every laptop.
  • In a formula, =UNICHAR(8377) returns the symbol in Excel 2013 or later and in Google Sheets. In Sheets, =CHAR(8377) also works; Excel's CHAR only handles codes up to 255, so use UNICHAR there.

How do I get the rupee symbol in Google Sheets?

Select the cells, open Format, Number and choose More formats, then Custom currencies. Search for INR or Indian Rupee, pick the entry and confirm. Or choose Custom number format and type "₹"#,##0.00 with the symbol in quotes. If you only want it as a default, set File, Settings, Locale to India, and the plain Currency button then uses the rupee symbol.

Why do I see a box or question mark instead of the symbol?

The font does not contain the character. This happens with older fonts, certain decorative fonts and older installations that never received the update that added the glyph. The fix is quick: change the font of those cells to a common one, such as Arial or Segoe UI, and check it on screen and in print preview. If it shows in the worksheet but not in a PDF, check the font embedded in the export. If you share the file, remember the receiver's device decides what shows.

Set the format once for a whole column rather than cell by cell. Select the column letter, apply the Currency format, and new rows typed underneath inherit it. In an Excel Table, formatting a column applies to the rows you add later. In Sheets, the same trick works with a column selected, and the Format as currency button on the toolbar applies whichever currency your locale prefers.

Why does a CSV with the rupee symbol look garbled?

Characters like ₹ in place of the symbol mean the file was saved or read in the wrong encoding. When you save from Excel, choose CSV UTF-8 from the Save As list. In Sheets, File, Download as CSV already writes UTF-8. When opening a CSV in Excel, use Data, From Text/CSV and set the file origin to UTF-8.

WhereMethodResult stays numeric?
ExcelCurrency or Accounting formatYes
ExcelCustom [$₹-4009] #,##0.00Yes
SheetsCustom currencies, INRYes
Either="₹"&A2No, it becomes text

Quick checklist

  • Format the cell, never glue a symbol to the number.
  • Test with a large amount to check column width.
  • Save CSVs as UTF-8.

SpendixAI keeps each expense in its own currency, with totals in your chosen base currency, so the symbol question mostly applies to the sheets you build yourself.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports