See
http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"sbsrose" wrote in message
...
Looking for a way to feed a $ amount from one cell to a different cell and
have it displayed as the dollar wording. i.e. $124.24 to One hundred
twenty
four dollars and 24/100.