Prev: from the text 4 pcs., how to remove only characters/text
Next: Yes - No Fill-ins & More
From: digit to text digit to on 24 May 2010 11:15
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"
From: Bernard Liengme on 24 May 2010 20:22
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

"digit to text" <digit to text(a)discussions.microsoft.com> wrote in message
news:6A174B0D-A48B-4788-8C8B-18D6921D91FE(a)microsoft.com...
> 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"

 | 
Pages: 1
Prev: from the text 4 pcs., how to remove only characters/text
Next: Yes - No Fill-ins & More