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

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.

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.

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.

The Format Cells dialog box will appear.

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

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.

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.

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.

• After that, press ENTER.

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.

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.

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

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

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.

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

• How to Insert Dollar Sign in Excel Formula
• How to Insert Tick Mark in Excel
• How to Put Equal Sign in Excel without Formula
• How to Put Sign in Excel Without Formula
• How to Write X Bar in Excel

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