Rupee font in excel formulas too !

Excel for Finance 4324 views 11 replies

CA Gaurav Rastogi

Finance & Account Officer

189 Points Posted on 13 October 2011

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.

Replies (11)

CA CWA Yugandar PR

Manager

139 Points Posted on 13 October 2011

Thanks Gaurav,

Its working. Thanks a lot.

Bhavika Gandhi

Assistant

22 Points Posted on 13 October 2011

Thanks, It is working once you set rupee foradian for excel and it will form part of the custom currnecy format.

CA Surendra Prajapati

Deputy Manager (Finance)

361 Points Posted on 13 October 2011

Thank You very much

radhika

CA FINAL

223 Points Posted on 13 October 2011

thank you

Pranab Banerjee

Software Maker & Income Tax Practisioner

12048 Points Posted on 13 October 2011

Thanks for this tips. I have also trying this Rupee Foradian Symbol in Excel Calcualtion Sheet but faild. Now it can possible, Thanks again Mr.Gourav

Pranab Banerjee

Mani

secretaru

26 Points Posted on 14 October 2011

Thanks Gaurav

It is really useful tip. Working good

V P Narasimhan

Accounts Manager

795 Points Posted on 14 October 2011

Its working Thanks but hw can we incorporate decimals or , for 1000 & so on

sanjeevcjos@gmail.com

25 Points Posted on 14 October 2011

Hi Gourav,

How can I add Rupee font in excell?

Sanjeev

Exshail

Software

1586 Points Posted on 14 October 2011

Originally posted by : V P Narasimhan
	Its working Thanks but hw can we incorporate decimals or , for 1000 & so on

Copy & paste below code to your personal macro workkbook & assign shortcut key.

Rupee Foradian font should be installed in your machine.

Sub Convert2IndRs()

' Macro recorded by Exshail Software
'

'
    With Selection
        .Font.Name = "Rupee Foradian"
        .NumberFormat = "$ #,##0.00_);($ #,##0.00)"
    End With

End Sub

Just Type ` #,##0.00_);(` #,##0.00)

in custom number format dialogbox with font Rupee Foradian.

Exshail
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
https://exshail.web.officelive.com/MenuAddins.aspx

Free Exshail Classic Menu for Excel-2007
https://exshail.web.officelive.com/Exshail_Classic_Menu.aspx

Exshail

Software

1586 Points Posted on 14 October 2011

Originally posted by : sanjeevcjos @ gmail.com
	Hi Gourav, How can I add Rupee font in excell? Sanjeev

Download attched zip file & unzip (to your desired folder e.g. my document folder)

It will unzip Rupee_Foradian.ttf file to your desired folder.

Now do below steps as under for windows XP like Operating Systems.

Start>Run

Type Fonts & press enter

it will open font directory

Click on File menu>Installed New Fonts>

It will popup new window to add fonts. From this window browse the folder where you just saved(unzipped) the font.
Press OK to Finish.

sushil

sr manager

21 Points Posted on 28 October 2011

Originally posted by : CA Gaurav Rastogi

Thanks Gaurav it workings keep sharing

sushil

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.