See all How-To Articles

How to Insert Rupee Symbol in Excel & Google Sheets

This tutorial demonstrates how to insert the rupee symbol in Excel and Google Sheets.

 

insert rupee sign final data

 

You can insert the rupee sign in Excel either as currency, using the number format, or by inserting a symbol.

Insert the Rupee Sign

Currency Number Format

Say you have the following data set with product names in Column B and product prices in Column C.

 

insert rupee sign initial data

 

As you can see, numbers in Column C are prices and should be formatted as amounts in rupees. To display the rupee sign, follow these steps:

1. (1) Select a range with numbers (here, C2:C8), and in the Ribbon, (2) go to Home and (3) click on the Number Format icon in the bottom right corner of the Number group.

 

insert rupee symbol format number

 

2. In the Format Cells window, (1) choose the Currency category from the right side, (2) click on the drop-down menu for Symbol, (3) select ₹ English (India), and (4) click OK.

 

insert-rupee sign format number 2

 

As a result, all values in the selected range now have the rupee symbol.

Note: The rupee sign should be positioned before a number when you format a number as a currency.

 

insert rupee sign final data

 

Insert Symbol

Another way to add the rupee sign is to insert it from Symbols. In this case, you can only insert a symbol in one cell at a time, then copy the symbol to the rest of the cells in the range. (If you do this often, you might want to automate the insertion with a VBA loop.)

1. Double-click the cell where you want to insert the rupee sign (e.g., C2), and in the Ribbon, go to Insert > Symbol.

If you just select a cell and insert a symbol, it will automatically add it at the end of a cell’s value (in this case it would be 70₹). Since you are inserting a currency symbol and it has to be before a number, double-click a cell to position the cursor before a number.

 

insert rupee symbol 1

 

2. In the Symbol window, (1) choose Currency Symbols from the Subset drop-down list, (2) select the Indian Rupee Sign (₹), (3) click Insert, and (4) Cancel.

 

insert rupee symbol 2a

 

The final result is the rupee sign inserted in cell C2, before the number. Excel automatically formats the cell as a currency.

 

insert rupee symbol 1

 

3. Now you can use the Format Painter to add the rupee sign to the rest of the values in Column C.

To store the rupee symbol as a character in the cell rather than a displayed format, change the cell format to text before Step 1 above.

Insert the Rupee Sign in Google Sheets

In Google Sheets, you can also insert the rupee sign into cells by formatting cells as currencies.

1. (1) Select a range with numbers (C2:C8), (2) click on the More formats icon (123) in the toolbar, (3) select More Formats and (4) click on More currencies.

 

insert rupee sign google sheets

 

2. In the Custom currencies window, (1) select Indian Rupee, (2) choose the appropriate format (1,000) and (3) click Apply.

 

insert rupee sign google sheets 2

 

The result is the same as in Excel, all values in the selected range now have the rupee sign in front of the values.

 

insert rupee sign google sheets final