Numbers in Excel

[Cassiel]

Does anyone knows how to write numbers in text format in excel?
E.G.: 125 € to "one hundred twenty five"

 

[Frank Kabel]

Hi
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

 

[Dave R.]

You can get MOREFUNC.DLL from

http://longre.free.fr/english/

and use function NBTEXT