Amount to Word Format

[Uthai]

Is it possible to convert a number amount in Excel into a
amount in words format like (USD 2520.25) into (USD
twothousandandtwentydollarsandtwentyfivecents)

Thank you in advance

Uthai

 

[Peo Sjoblom]

With VBA only, see below for example

http://support.microsoft.com/default.aspx?scid=kb;en-us;213360

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Uthai]

Thanks,

Will look at that link.

Rgds,

Uthai

 

[Uthai]

Peo,

Sorry bother you one more time. It worked perfect
however, I expressed myself wrong, I need exactly the
mumbers how you gave me the link to it, however I have to
eliminate the currency side of it. Any suggestion how
that can be done?

Uthai