Convert $25,220.20 to 'twenty five thousand two hundred twenty two and cents twenty'?

[tunabread]

Hi all,

Anyone knows how to convert $25,220.20 to 'twenty five thousand two hundred twenty two and cents twenty'?

I believe this is similiar in banking machines.
Do I need a macro to work, because no formula can do that...
Any help/advices is highly appreciated!

[Ron Coderre]

The VBA code you need is right in one of these forums at:

http://www.exceltip.com/st/Formulas_...Excel/301.html

The function definition is towards the bottom of that site.

Regards,
Ron

[tunabread]

Thank you Ron so much! I have been searching for a long timr and finally got it from you