How to Insert Rupee Symbol in Excel (7 Quick Methods)

If you want to insert rupee symbol in Excel, you have come to the right place. In this article, we will describe 7 easy methods that will help you to do the task effortlessly.

Download Workbook


7 Methods to Insert Rupee Symbol in Excel

The following Insert Rupee Symbol in Excel table has ID No. , Item, and Cost columns. In the Cost column, we will insert a rupee symbol. Here, we will use Excel 365, you can use any available Excel version.

How to Insert Rupee Symbol in Excel


Method-1: Applying Currency Format to Insert Rupee Symbol in Excel

In this method, we will apply the Number Format to insert rupee symbol in Excel.

Steps:

  • First, we will select the data of the Cost column > go to the Home tab > click on Number Format which is marked with a red color box > select More Number Formats.

A Format Cells dialog box will appear.

  • Afterward, in the Category we will select Currency > in the Symbol box select ₹ English (India) > click OK.

Finally, in the Cost column, we can see the rupee symbol.

How to Insert Rupee Symbol in Excel

Read More: How to Insert Symbol in Excel (6 Simple Techniques)


Method-2: Use of Format Cells Option to Insert Rupee Symbol in Excel

Here, we will use the Format Cells option to insert rupee symbol in Excel.

Steps:

  • First, we will select the data from the Cost column.
  • After that, we will right-click.

A Context Menu will appear.

  • Then, we will select Format Cells.

How to Insert Rupee Symbol in Excel

A Format Cells dialog box will appear.

  • Afterward,  select Category as Category > then from Symbol box select ₹ English (India) > click OK.

How to Insert Rupee Symbol in Excel

Finally, in the Cost column, we can see the rupee symbol.

Read More: How to Put Sign in Excel Without Formula (5 Ways)


Method-3: Inserting Rupee Symbol Using Symbols Feature

In this method, we can insert rupee symbol from the Symbols option in Excel.

Steps:

  • First, we will select cell D5 > go to the Insert tab > from Symbols option > select Symbol.

A Symbol dialog box will appear.

  • Afterward, we will select the rupee (₹) symbol from that box > click on Insert > click on Close.

How to Insert Rupee Symbol in Excel

Now, we can see a rupee (₹) symbol in cell D5.

  • After that, in a similar way, we inserted a rupee (₹) symbol in the cells of the Cost column.

How to Insert Rupee Symbol in Excel

Read More: How to Insert Sign in Excel Formula (Arithmetic, Logical and Misc.)


Similar Readings


Method-4: Using UNICHAR Function

Here, we will use the UNICHAR function to insert rupee symbol. This function is only applicable for Excel 2013 and higher versions of Excel.

Steps:

  • First, we will type the following formula in cell E5.
=UNICHAR(8377)&" "&D5

Formula Breakdown

  • UNICHAR(8377) → returns a rupee () symbol.
  • UNICHAR(8377)&” “&D5 → Here, the Ampersand (&) sign joins the rupee () symbol and cell D5 together.
    • Output₹ 100
  • After that, press ENTER.

How to Insert Rupee Symbol in Excel

We can see the result in cell E5.

  • Afterward, we will drag down the formula with the Fill Handle tool.

Finally, in the Cost in Rupee column we can see the rupee symbol.

How to Insert Rupee Symbol in Excel

Read More: How to Insert Dollar Sign in Excel Formula (3 Handy Methods)


Method-5: Insert Rupee Symbol by Using Control Panel

In this method, we will use the Control Panel App to change the default currency symbol to the rupee symbol. And we will show you how to insert a rupee symbol in Excel.

Steps:

  • First, we will click on the Start button of the Windows.

How to Insert Rupee Symbol in Excel

  • Then, we will type Control Panel and we will select the Control Panel App.

A Control Panel dialog box will appear.

  • After that, we will select Clock and Region.

A Clock and Region window will appear.

  • Next, we will select Region.

A Region window will appear.

  • Afterward, we will click on the down arrow marked with a red color box of the Format box > select Hindi (India).

How to Insert Rupee Symbol in Excel

  • After that, we will click on Apply > click OK.

  • Then, we will close the Clock and Region dialog box.

  • Afterward, we will return to our Excel sheet > select the Cost column > go to the tinyab > click on Accounting Number Format marked with a red color box.

Finally, in the Cost column, we can see the rupee symbol.

How to Insert Rupee Symbol in Excel

Read More: Excel Formula Symbols Cheat Sheet (13 Cool Tips)


Method-6: Employing Windows Settings Option to Insert Rupee Symbol

Here, we will show you how to change the default currency symbol to the rupee symbol from the Windows Setting option. After that, we will show you how to insert a rupee symbol in Excel.

Steps:

  • First, we will click on the Start button of the Windows.

  • Then, we will type Settings and we will select the Settings App.

A Settings dialog box will appear.

  • Next, we will select Time & Language.

  • After that, we will select Region.

  • Next, we will select Additional date, time & regional settings.

How to Insert Rupee Symbol in Excel

A Clock and Region window will appear.

  • Afterward, we will select Region.

  • After that, we will follow the steps described in Method-5.

Finally, in the Cost column, we can see the rupee symbol.

Read More: How to Add Symbol Before a Number in Excel (3 Ways)


Method-7: Using Currency Display Feature from the Control Panel

In this method, we will insert rupee symbol in Excel by using the Change the way currency is displayed feature.

Steps:

  • First, we will click on the Start button of the Windows.

 

  • Next, we will select Change the way currency is displayed.

A Region dialog box will appear.

  • Next, we will follow the steps described in Method-5.

Finally, in the Cost column, we can see the rupee symbol.

Read More: How to Insert Symbol in Excel Header (4 Ideal Methods)


Conclusion

Here, we tried to show you 7 methods to insert a rupee symbol in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section. Please visit our website Exceldemy to explore more.


Related Articles

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo