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