Is there any function that allows me to convert number into their equivelent in words? Please advise
A AAMC Aug 21, 2005 #1 Is there any function that allows me to convert number into their equivelent in words? Please advise
B Bob Phillips Aug 21, 2005 #2 See http://www.xldynamic.com/source/xld.xlFAQ0004.html -- HTH RP (remove nothere from the email address if mailing direct)
See http://www.xldynamic.com/source/xld.xlFAQ0004.html -- HTH RP (remove nothere from the email address if mailing direct)
A Andy Wiggins Aug 21, 2005 #3 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 the "SPELLNUMBER" function, which can be used in your spreadsheets, two methods to convert numbers to words and two cheque writing routines. The code is open and commented.
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 the "SPELLNUMBER" function, which can be used in your spreadsheets, two methods to convert numbers to words and two cheque writing routines. The code is open and commented.
