how to convert numeric into words hitesh 01.09.2006 04:38:01 1) i want 120 to one hundred and twenty only 2) 120.50 to one hundred twenty rupees and fifty paise only these are the 2 quest pls help me

Re: how to convert numeric into words "Bob Phillips" <bob.NGs[ at ]somewhere.com> 01.09.2006 07:35:37 See http://www.xldynamic.com/source/xld.xlFAQ0004.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "hitesh" <hitesh[ at ]discussions.microsoft.com> wrote in message news:C498EEA4-D37B-4580-8650-2DA2A8866BA8[ at ]microsoft.com... [Quoted Text] > 1) i want 120 to one hundred and twenty only > > 2) 120.50 to one hundred twenty rupees and fifty paise only > these are the 2 quest pls help me

Re: how to convert numeric into words "Andy Wiggins" <contact me via my website at www.BygSoftware.com> 01.09.2006 07:45:13 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. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "hitesh" <hitesh[ at ]discussions.microsoft.com> wrote in message news:C498EEA4-D37B-4580-8650-2DA2A8866BA8[ at ]microsoft.com... [Quoted Text] > 1) i want 120 to one hundred and twenty only > > 2) 120.50 to one hundred twenty rupees and fifty paise only > these are the 2 quest pls help me