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

Get FREE Advanced Excel Exercises with Solutions!

If you want to insert the 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.


How to Insert Rupee Symbol in Excel: 7 Quick Methods

The following dataset has ID No., Item, and Cost columns. In the Cost column, we will insert a rupee symbol. Here, we will use the Microsoft Office 365 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 the rupee symbol in Excel.

Steps:

  • First, 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.

The Format Cells dialog box will appear.

  • In the Category 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 Header


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

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

Steps:

  • We will select the data from the Cost column.
  • After that, we will right-click on the mouse.
  • From Context Menu select Format Cells.

How to Insert Rupee Symbol in Excel

The Format Cells dialog box will appear.

  • Select Accounting as Category > From the Symbol box select ₹ English (India) > Click OK.

How to Insert Rupee Symbol in Excel

We can see the rupee symbol in the Cost column.

Read More: How to Insert Symbol in Excel Footer


Method-3: Inserting Rupee Symbol Using Symbols Feature

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

Steps:

  • Select cell D5 > Go to the Insert tab > From Symbols option > Select Symbol.

The Symbol dialog box will appear.

  • Next, we will select the Indian Rupee Sign (₹) symbol from that box > Click on Insert > Click on Close.

How to Insert Rupee Symbol in Excel

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

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

How to Insert Rupee Symbol in Excel


Method-4: Using UNICHAR Function

Here, we will use the UNICHAR function to insert the rupee symbol. This function is only applicable to Microsoft Office 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.

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

How to Insert Rupee Symbol in Excel

Read More: How to Insert Sign in Excel Formula


Method-5: Insert Rupee Symbol by Using Control Panel

In this method, we will use the Control Panel 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 application.

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 the Region option.

The Region window will appear.

  • We will click on the down arrow marked with a red color box in 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 Number group > 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


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 Settings option.

Steps:

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

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

The Settings dialog box will appear.

  • Next, we will select Time & Language.

  • After that, we will select the Region.

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

How to Insert Rupee Symbol in Excel

The 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.


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

In this method, we will insert the 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.

  • The 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.


Download Workbook


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 to explore more.


Related Articles


<< Go Back to Insert Symbol in Excel | Excel Symbols | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo