Home > Miscellaneous > Indian Rupee Symbol in Excel Cell Format

Indian Rupee Symbol in Excel Cell Format


In this small article I will show you how to format a Cell to represent Indian Rupee Symbol in Excel.

As I have explained in my previous post how to create a Indian Rupee Symbol by using Private character editor. Same symbol can be used to format Cell in Excel.

Steps to follow ->

Click Start -> Run -> Type charmap.exe

clip_image002

Double click on the Indian Rupee Symbol and Click the Copy button

Open excel file.

Select the cells to format

Right Click on cells and Select Format Cells…

image

Click on Custom Category

Click on the Type Textbox and Press Ctrl + V to paste Indian Rupee Symbol

clip_image006

Format the text as shown below

clip_image008

Click Ok

image

That’s it.

About these ads
  1. Vijay Malhotra
    February 15, 2011 at 4:11 PM

    pls help me. I can use symbal though only in font type of ` (upper key of tab) not in excel format cell. I think I need something more software to add Indian rupees symbal.

  2. Mohammad Amin
    March 10, 2011 at 12:24 PM

    After Double click on the Indian Rupee Symbol and Click the Copy button. Then we have to Click on “Start” then “Control Panel” then “Date,Time,Language, Regional Options” then “Change the Numbers,Format, Date & Time” then “Customize” then “currency” and Click in the currency symbol box and Press Ctrl + V to paste Indian Rupee Symbol and then OK.
    Note: After that whenever you format an excel cell as currency when you fill up the number INR symbol will display automatically. (May be this will help to operators) Khans

    • Md Khurshid Alam
      June 9, 2012 at 8:28 PM

      Thanks Amin Bhai, This is best option.
      Thanks once again.

  3. Aarti
    March 16, 2011 at 3:08 PM

    Can you please help me to format a Cell to represent Indian Rupee Symbol in excel. I have read your artical but I cant do that way.

    • MSCoder
      March 16, 2011 at 9:13 PM

      Yes, tell me what help you need.

  4. arjun bagri
    May 23, 2011 at 1:25 PM

    Hi, I do not have the all font selection in the charmap dialog box. please help!

  5. Dharmendra
    May 23, 2011 at 5:07 PM

    When I press Ctrl + V it is pasting ` only not rupee symbol. Although I have already installed the Rupee font in the system. Please help.

  6. June 20, 2011 at 2:53 PM

    i followed ur step to insert the symbol but it didnt paste in cusmtom catagory type box.please tell me how to insert this symbol.

    • Madhu
      July 15, 2011 at 9:03 PM

      hi can u pls help me how to add the rupee symbol in excel, i followed above steps instead of pasting symbol it pastes “`” (upper the tab key). and also i have this font but when i see formula bar it shows “`” not the symbol in excel. pls help me

      • MSCoder
        July 15, 2011 at 9:15 PM

        If you have followed all the steps then Rupee Symbol will be available in Character Map.

        Select the Created Symbol from Character Map Instead of pressing the key “`”.

    • MSCoder
      July 15, 2011 at 9:23 PM

      You need to select the Symbol in Character Map and then Click on Copy button as shown in first image of this post…
      then paste it in Custom Type Textbox of Format Cells Dialog box..

  7. dirus
    August 26, 2011 at 12:15 PM

    That was so simple yaarrrrrrrrrr THANKS!

    • deepak
      January 20, 2012 at 1:59 PM

      me too tried the same but rupee symbol was not found only “`” is appearing.

  8. Tamizhanban
    September 21, 2011 at 5:02 PM

    Rupee symbol is not appearing in charmap. What to do

  9. Nirmal
    December 22, 2011 at 4:32 PM

    the symbol is coming correct in character map, but when i paste in format cells it shows as a differnt symbol

  10. D.Jegan Daniel
    March 20, 2012 at 11:12 AM

    Hi,
    Good day..

    How to use the Rupee symbol in Excel for calculation purpose as dollar symbol selection.

  11. James
    June 14, 2012 at 3:10 PM

    Thanks for the idea. But it is working only in Windows xp. I tried to do the same in Windows 7 but it is not working. Please help.

  12. sameer
    August 11, 2012 at 2:36 PM

    thanks @ mohammed ameen. ur idea work properly.
    configure in windows control panel is better. by which we can choose format cell > currency in excel. it’s simple

  13. Arunkumar Bhattacharyya
    October 16, 2012 at 10:12 PM

    Thanks. Only addition is that to convert cell range to “Rupee” font, otherwise it shows like “` “

  14. Srinivasa Rao K V
    December 1, 2012 at 12:06 PM

    Sir While trying to type rupee symbol in charmap.exe. while maping it got currepted how can i install new charmap.exe file. can u help me out.

  15. Jon
    March 24, 2013 at 9:11 AM

    After following all the steps,i still have a square box when pasting in the format cells tab

  16. Nilanjan Dev, Silchar, Assam
    April 30, 2013 at 3:33 PM

    Thank you Sir for your valuable guidance

  17. pooja
    December 11, 2013 at 11:49 PM

    i have followed all the steps but it makes symbol of ” ` ” and when i want to change font in “ruppe” it does not appear in font option.what should i do ?? plz help me

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: