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

The following datasetÂ has ID No., Item, and Cost columns.

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

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

The Format Cells dialog box will appear.

• In Category, select AccountingÂ > In Symbol, select â‚¹ English (India) > Click OK.

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.

The rupee (â‚¹) symbol will be displayed in D5.

• Insert the rupee (â‚¹) symbol in the other cells.

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

See the result in E5.

• The Cost in Rupee will be displayed.

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.

• Select Control Panel.

The Control Panel dialog box will appear.

• Select Clock and Region.

A Clock and Region window will appear.

• Next, we will select the Region option.

TheÂ Region window will appear.

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

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

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

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

Advanced Excel Exercises with Solutions PDF