Convert numbers to text

  • Thread starter Thread starter Mike
  • Start date Start date
M

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.
 
Mike said:
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.
Click to expand...

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
 
Back
Top