Converting Numbers to Text

[Tansu]

Hi,

I need to convert some numbers to text, such as 32.5
to "Thirty two point five".

Actually, I have found the solution on the web and MS
support site.

The solution is the use of "SpellNumber" function as
described in the following link.

The problem is that I tried it in Excel, but it did not
recognize the function. I checked in the Function wizard
and there is no function named "SpellNumber" in the
functions list.

Can you please help me about it? How can make spellnumber
function work?

Thanks,
Tansu

 

[Frank Kabel]

Hi
you have to copy this code in one of your VBA modules. You may also
have a look at some other solutions (including one Add-in):
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