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