PLEASE HELP - Display number in extended text

  • Thread starter Thread starter Felipe
  • Start date Start date
F

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