See if NumsToWords functions at this site help (2 options: VBA or non-vba):
http://www.contextures.com/excelfilesRon.html

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Melissa" wrote in message ...
I am working on a workbook that is several pages. I have one page that gives
me a total that i need to appear as text in another worksheet. How would I
get $100.00 to appear on another page as One Hundred Dollars and No Cents?

--
Melissa