I want to make convert a number in words in excel

[Guest]

i want excel to convert any number in words automatically
for example cell A1 total is 100
then in cell A2 excel should put " ONE HUNDRED"

 

[Bernard Liengme]

See any of these:
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

best wishes