Inserting Rupee Symbol
Background

Rupee symbol dervied official recognisation in the year 2010. Windows 7 onwards it is supported in all versions. It was introduced in unicode as separate sybmol . Unfortunately dedicated key like $ for symbol is not available in Keyboard. So, various methods to insert it in Excel are discussed in this article.

Using MS-Word
  1. Open MS-Word
  2. Write 20B9
  3. Press Alt + X
  4. Given text will convert to rupee symbol
  5. Copy and Paste it in Excel
Using UNICHAR function in Excel
  1. Write =UNICHAR(8377) in any cell
  2. Copy and Paste-special the value wherever required
Note: UNICHAR function is supported in Excel 2013 or higher version or Office 365 only
Using Excel-BI add-in
Excel-BI add-in supports one-click inserting of Rupee symbol. More details of this add-in can be found in below link
https://erpcloudanalysis.in/excel-bi/rupee-symbol
Watch Tutorial
Try Online