Numbers to Text
 

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

Numbers to Text
 

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)



"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

Numbers to Text
 

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