Numbers to words

[mathcode]

I am trying to create a spreadsheet for my fifth grade math class. I'd like to enter an number, say 1.542, and have Excel convert it to word form "one and five hundred forty two thousandths."

I've seen routines for working with money into trillions, but nothing extends beyond hundredths for the smaller decimal values.

Any thoughts on how to accomplish this feat?

Mathcode

 

[Asheesh]

@mathcode

Hope this helps...

Source: http://support2.microsoft.com/kb/213360

Made minor changes..let me know if you need something else..

Regards
Asheesh