How to Insert the Rupee Symbol in Excel -7 Quick Methods

The following dataset showcases ID No., Item, and Cost columns.

How to Insert Rupee Symbol in Excel


Method 1 – Applying the Currency Format to Insert the Rupee Symbol in Excel

Steps:

  • Select the data in the Cost column > Go to the Home tab > Click Number Format > Select More Number Formats.

The Format Cells dialog box will appear.

  • In Category, select Currency > In Symbol, select ₹ English (India) > Click OK.

The rupee symbol will be displayed in the Cost column.

How to Insert Rupee Symbol in Excel


Method 2 – Using the Format Cells Option to Insert the Rupee Symbol in Excel

Steps:

  • Select the data in the Cost column.
  • Right-click.
  • Select Format Cells.

How to Insert Rupee Symbol in Excel

The Format Cells dialog box will appear.

  • In Category, select Accounting > In Symbol, select ₹ English (India) > Click OK.

How to Insert Rupee Symbol in Excel

The rupee symbol will be displayed in the Cost column.

Read More: How to Insert Symbol in Excel Footer


Method 3 – Inserting the Rupee Symbol Using the Symbols Feature

Steps:

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

The Symbol dialog box will appear.

  • Select the Indian Rupee Sign (₹) > Click Insert > Click Close.

How to Insert Rupee Symbol in Excel

The rupee (₹) symbol will be displayed in D5.

  • Insert the rupee (₹) symbol in the other cells.

How to Insert Rupee Symbol in Excel


Method 4 –  Using the UNICHAR Function

Steps:

  • Enter the following formula in E5.
=UNICHAR(8377)&" "&D5

Formula Breakdown

  • UNICHAR(8377) → Returns the rupee (₹) symbol.
  • UNICHAR(8377)&” “&D5 → The ampersand (&) joins the rupee (₹) symbol and D5.
    • Output₹ 100
  • Press ENTER.

How to Insert Rupee Symbol in Excel

See the result in E5.

The Cost in Rupees will be displayed.

How to Insert Rupee Symbol in Excel

Read More: How to Insert Sign in Excel Formula


Method 5 – Insert the Rupee Symbol by Using the Control Panel

Steps:

  • Click the Windows Start button.

How to Insert Rupee Symbol in Excel

  • Select Control Panel.

The Control Panel dialog box will appear.

  • Select Clock and Region.

A Clock and Region window will appear.

  • Select Region.

The Region window will appear.

  • Click the down arrow in the Format box > Select Hindi (India).

How to Insert Rupee Symbol in Excel

  • Click Apply > Click OK.

  • Close the Clock and Region dialog box.

  • Return to your Excel sheet > Select the Cost column > Go to Number > Click Accounting Number Format.

The rupee symbol will be displayed in the Cost column.

How to Insert Rupee Symbol in Excel


Method 6 – Using the Windows Settings Option to Insert the Rupee Symbol

Steps:

  • Click the Windows Start button.

  • Select the Settings application.

The Settings dialog box will appear.

  • Select Time & Language.

  • Select the Region.

  • Select Additional date, time & regional settings.

How to Insert Rupee Symbol in Excel

The Clock and Region window will appear.

  • Select Region.

  • Follow the steps described in Method 5.

The rupee symbol will be displayed in the Cost column.


Method 7 – Using the Currency Display Feature from the Control Panel

Steps:

  • Click the Windows Start button.

  • Select Change the way currency is displayed.

The Region dialog box will appear.

  • Follow the steps described in Method-5.

The rupee symbol will be displayed in the Cost column.


Download Workbook


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of NAME from Bangladesh 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 interested... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo