View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
shapiro shapiro is offline
external usenet poster
 
Posts: 34
Default convert $10.20 to text ...Ten Dollars &20/100

i All,
I found this amazing website

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

When you type $10.20 on the check the words spell out as Ten dollars
&20/100. It makes my personal checks look official!!! However, I would love
to have the words print as Ten Dollars & 20/100***********. I have been
playing around with the code but I am unable to put it the ********. Does
anyone know how to do this?
Thanks a mil