CONVERT NUMBER TO TEXT

[adeel via OfficeKB.com]

Please tell me the formula to convert Number value to Text value (eg. 10,000
convert to Ten Thousand)
thanks

 

[Niek Otten]

Look here:

http://xldynamic.com/source/xld.xlFAQ0004.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Please tell me the formula to convert Number value to Text value (eg. 10,000
| convert to Ten Thousand)
| thanks
|
| --
| Message posted via OfficeKB.com
| http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200706/1
|

 

[Bernard Liengme]

Some more:
Bob Phillips' site for help on this.

http://www.xldynamic.com/source/xld.xlFAQ0004.html

or Bernd Plumhoff's site

http://www.sulprobil.com/html/spellnumber.html

or

http://www.ozgrid.com/VBA/ValueToWords.htm

or

http://support.microsoft.com/?kbid=213360