G Guest May 8, 2005 #1 How Can I Change the Numbers to Words in Excel. Eg I want to chnge 9001 to "Nine Thousand and One Only"
How Can I Change the Numbers to Words in Excel. Eg I want to chnge 9001 to "Nine Thousand and One Only"
H Harald Staff May 8, 2005 #2 Hi Excel has no built-in method for this. Use Laurent Longre's addin Morefunc: http://xcell05.free.fr/ HTH. Best wishes Harald
Hi Excel has no built-in method for this. Use Laurent Longre's addin Morefunc: http://xcell05.free.fr/ HTH. Best wishes Harald
A Andy Wiggins May 9, 2005 #4 This file might be a help: 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 to convert numbers to words and two cheque writing routines. The code is open and commented. -- Regards - Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy
This file might be a help: 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 to convert numbers to words and two cheque writing routines. The code is open and commented. -- Regards - Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy
