See one or more of these
Excel converting numbers to text
http://support.microsoft.com/default...b;en-us;213360
http://www.codearchive.com/code/0200...xtfunction.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/o...ult.aspx#tab=4

"digit to text" <digit to wrote in message
...
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"