How to convert currency into words?

[Guest]

Can anyone advise how do I convert 1,223.35 to ONE THOUSAND TWO HUNDRED
TWENTY THREE DOLLARS AND THIRTY FIVE CENTS?

Would prefer to have a formula to do this, instead of via VBA.

Thanks!!!

 

[JulieD]

Hi Derrick

there is no inbuilt function for this - you need to use an add-in or code
.... check out
http://www.xldynamic.com/source/xld.xlFAQ0004.html

for details
Cheers
JulieD