Can a $figure be converted to words in another cell
 

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.

Can a $figure be converted to words in another cell
 

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.

Can a $figure be converted to words in another cell
 

The attached link has VBA code which might help

http://www.ozgrid.com/VBA/ValueToWords.htm


VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=568851