Say it in words

[Sena]

Hi,

Am doing an invoice in Excel and need to print the value in words. |For
example if the total of invoice is $ 100.00, in the next cell it should write
" One hundred and cents zero "

Is there any formula to get this result ?

Thanks

 

[L. Howard Kittle]

From a post in another newsgroup.

See Bob Phillips' site

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


Gord Dibben MS Excel MVP

HTH
Regards,
Howard

 

[FSt1]

hi
not a "built in" fomula. maybe an UDF. others have had this need too.
see these sites.
http://www.xldynamic.com/source/xld.xlFAQ0004.html
http://www.sulprobil.com/html/spellnumber.html
http://support.microsoft.com/?kbid=213360

regards
FSt1