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
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…
Click on Custom Category
Click on the Type Textbox and Press Ctrl + V to paste Indian Rupee Symbol
Format the text as shown below
Click Ok
That’s it.
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.
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
Thanks Amin Bhai, This is best option.
Thanks once again.
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.
Yes, tell me what help you need.
Hi, I do not have the all font selection in the charmap dialog box. please help!
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.
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.
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
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 “`”.
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..
That was so simple yaarrrrrrrrrr THANKS!
me too tried the same but rupee symbol was not found only “`” is appearing.
Rupee symbol is not appearing in charmap. What to do
the symbol is coming correct in character map, but when i paste in format cells it shows as a differnt symbol
Hi,
Good day..
How to use the Rupee symbol in Excel for calculation purpose as dollar symbol selection.
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.
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