Convert numbers to text

[Mike]

Is there an easy way to code a macro to convert numbers to
text. For example 22,600.00 is converted to twenty two
thousand six hundred.

I know I could write code using "mid" to evaluate each
number in 22,600.00 but that seems cumberson.

Any ideas would be greatly appreciated. Thanks for the
help.

 

[Frank Kabel]

Is there an easy way to code a macro to convert numbers to
text. For example 22,600.00 is converted to twenty two
thousand six hundred.

I know I could write code using "mid" to evaluate each
number in 22,600.00 but that seems cumberson.

Any ideas would be greatly appreciated. Thanks for the
help.

Hi Mike
This is common question. Try doing a Google search and you'll find a
lot. Below a short list for this topic:
MS Knowledge Base:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360
http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

or have a look at
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods

Frank