I need to show on an invoice, the total amount of the transaction in dollars,
but also must have this amount written our in words. Example:

125.00 ONE HUNDRED TWENTY FIVE AND ZERO CENTS

thanks,

Peter Hoffmann


"JOUIOUI" wrote:

This worked great, thanks a bunch. I just realized I have one other
spreadsheet that I just need the sum in column A for the entire column. I've
tried manipulating this code, but it's not working for me. Again it is an
unknown cell because the report varies in length each day.

"Tristan" wrote:


Oops

Sorry forgot about the currency thing....


rng.Offset(3, 0).Value = Application.Count(Range("B1", rng))
rng.Offset(3, 0).Font.Bold = True
rng.Offset(3, 0).NumberFormat = "General"

If general doesn't do the job try swapping it for "Text"


--
Tristan
------------------------------------------------------------------------
Tristan's Profile: http://www.excelforum.com/member.php...o&userid=34061
View this thread: http://www.excelforum.com/showthread...hreadid=548773