Numbers to Text

[Guest]

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?

 

[Bob Phillips]

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

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Ron Coderre]

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)