Dear CCIites,
Till now, i was able to use Rupee Font (Rupee Symbol) using Rupee Foradian Font. But I was unable to use it in formulas as currenct formats. In Rupee Foradian Font you can press character " ` ". This is left most character on the keyboard adjecant to 1.
Now I have thought that it can also be used in Excel while calculating formulas too.
Go to FORMAT CELLS, then
Go to NUMBER TAB, then
Go to CUSTOM CATEGORY, then
Paste it " ` 0.00 " in "TYPE" (Only these 5 character)
Now if you have already downloaded Rupee Foradian Font (if not, then search it on google and download it from any site), then
Go to any cell, type the amount, then Go to Font and set the font Rupee Foradian,
And you are able to use Rupee Symbol as currency format in formulas too !
Guys and Gals, Give my your feedback.
CAclubindia
