Say it in words
 

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
--
Cheers !

Say it in words
 

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


"Sena" wrote in message
...
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
--
Cheers !

Say it in words
 

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


"Sena" wrote:

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
--
Cheers !