D David Aug 26, 2003 #1 I am looking for a formula to spell out dollars and oo/100. I tried =Spelldollars($) but it didn't work.
I am looking for a formula to spell out dollars and oo/100. I tried =Spelldollars($) but it didn't work.
A Andy Wiggins Aug 27, 2003 #2 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 www.BygSoftware.com Home of "The Excel Auditor" and "Byg Tools for VBA"
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 www.BygSoftware.com Home of "The Excel Auditor" and "Byg Tools for VBA"
