convert currency to text in Excel ($2,000 to Two Thousand)

[Brinton]

Is there a way to convert a currency value such as $2,000 in one column to a
narrative value of "two thousand" in another column? If so, will it work for
included decimal values; $2,000.20? Thanks

 

[Gord Dibben]

See Bob Phillips' site for methods.

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


Gord Dibben MS Excel MVP