View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Total in Money Converted into Letters!!!

For numbers to words see
Bob Phillips' site for help on this.
http://www.xldynamic.com/source/xld.xlFAQ0004.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"Edgar" wrote in message
...
Hi All,
My Excel program has a TOTAL at the end of all the Items
sold. But on the bottom of that, I have to fill in everytime
in letters of what the TOTAL gives me. Is there any way
to make that happen by itself?

Exp. TOTAL is $900.00
On the other line, I have to fill in:
Nine Hundred Dollars and 00/100
and I do a lot of this and sometimes
I dont write the exact amount, so I
want to know if anybody knows of a
better way to do this. Thank You.
--
Computer Tech