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