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.

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.

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.

A Format Cells dialog box will appear.

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

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.

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.

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

Similar Readings

• How to Type Minus Sign in Excel Without Formula (6 Simple Methods)
• Put 0 in Excel in Front of Numbers (5 Handy Methods)
• How to Insert Tick Mark in Excel (7 Useful Ways)
• Type Delta Symbol in Excel (8 Effective Ways)
• How to Type Diameter Symbol in Excel (4 Quick Methods)

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.

• After that, press ENTER.

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.

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.

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

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

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.

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

• How to Insert Degree Symbol in Excel (6 Suitable Methods)
• Insert Symbol in Excel Footer (3 Effective Ways)
• How to Type Math Symbols in Excel (3 Easy Methods)
• Put Equal Sign in Excel without Formula (4 Easy Ways)
• How to Put a Plus Sign in Excel without Formula (3 Easy Methods)
• Insert Greater Than or Equal to Symbol in Excel (5 Quick Methods)
• How to Insert Less Than or Equal to Symbol in Excel (5 Quick Methods)