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"

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"

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

http://www.dq.winsila.com/tips-trick...and-words.html

all the best