G Guest Apr 5, 2004 #1 Does anyone knows how to write numbers in text format in excel? E.G.: 125 € to "one hundred twenty five"
Does anyone knows how to write numbers in text format in excel? E.G.: 125 € to "one hundred twenty five"
F Frank Kabel Apr 5, 2004 #2 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
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
D Dave R. Apr 5, 2004 #3 You can get MOREFUNC.DLL from http://longre.free.fr/english/ and use function NBTEXT
