Converting Numbers to Text

T

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top