a function which accepts a number and returns it in words

[aa]

In Excel is there a function which accepts a number and returns it in words,
eg myFunction(15) return "fifteen"

 

[Niek Otten]

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| In Excel is there a function which accepts a number and returns it in words,
| eg myFunction(15) return "fifteen"
|
|

 

[Bernard Liengme]

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 Ozgrid

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

or MS

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

best wishes

 

[aa]

thanks