A Andy Wiggins Jul 7, 2004 #2 There never was a formula called SpellNumber made available with Excel. However, you might be thinking of the SPELLNUMBER function that is available in the following download: 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 www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA"
There never was a formula called SpellNumber made available with Excel. However, you might be thinking of the SPELLNUMBER function that is available in the following download: 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 www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA"