Can a $figure be converted to words in another cell

[sbsrose]

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.

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[VBA Noob]

The attached link has VBA code which might help

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


VBA Noo