Thread: Say it in words
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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 !