PLEASE HELP - Display number in extended text

[Felipe]

I am looking for a function that will show a number in
its full text.
For Example: you input the value 1250.00 in a cell (A1)
This function when referenced to the cell A! will return
the following text: "One Thousand two hundred and fifty"

I know that there is a function that does this, but I
can't find it. Especially since there is the BAHTTEXT
which does exactly this, but in BAHT language, which
isn't much usefull for me right now.

Thanks

Felipe

 

[Frank Kabel]

Hi Felipe
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