120= rupees one hundred twenty only

[digit to text]

i just want to know the formula which translate digit to text for example if
120 written in any cell and other cell we want result "rupees one hundred
twenty only"

 

[Bernard Liengme]

See one or more of these
Excel converting numbers to text
http://support.microsoft.com/default.aspx?scid=kb;en-us;213360
http://www.codearchive.com/code/0200/0220-currencytextfunction.txt
http://www.xldynamic.com/source/xld.xlFAQ0004.html
http://www.ozgrid.com/VBA/ValueToWords.htm
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

REMEMBER: Microsoft is closing the newsgroups; We will all meet again at
http://answers.microsoft.com/en-us/office/default.aspx#tab=4

 

[bala_vb]

i just want to know the formula which translate digit to text fo
example if
120 written in any cell and other cell we want result "rupees on
hundred
twenty only"

an excel add in, that shows numeric to indian format words.

http://tinyurl.com/22m77xw

all the bes