How to convert currency into words?

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!!!

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

"Derrick" <Derrick@discussions.microsoft.com> wrote in message
news:A2E0EC09-DEE9-4C93-81D9-8CC58C4344BA@microsoft.com...
> 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!!!
>