How can I change the currency to words?i.e. $10 to Ten Dollars
 

How can I change the currency to words?i.e. $10 to Ten Dollars
 

requires a custom function using VBA/macro.

Google for "number to words", and you'll get a few, for example:

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

Regards
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=548840

How can I change the currency to words?i.e. $10 to Ten Dollars
 

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

--
HTH

Bob Phillips

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

"Nancy" wrote in message
...