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

[Mikeopolo]

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
Mik

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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