Re: $$Excel-Macros$$ How to Convert words in digits.

2012-07-20 Thread jmothilal
spellnumber function working only number to text only On Fri, Jul 20, 2012 at 5:17 PM, Ashish kumar wrote: > Dear All, > > Greetings for the day...! > > > I have trying to convert Text to numbers (digits), and I h've apply the > formula (spellnumber), but this is not working. please

Re: $$Excel-Macros$$ How to Convert words in digits.

2012-07-20 Thread Ashish kumar
Dear All, Greetings for the day...! I have trying to convert Text to numbers (digits), and I h've apply the formula (spellnumber), but this is not working. please help me to convert this, & is this possible to convert it with formula not with the help of VB codeing. Example :- Four T

Re: $$Excel-Macros$$ How to Convert words in digits.

2012-07-17 Thread kumar.ashish861
Dear Noorain, Thanks to provide a valuable support. On Tuesday, July 17, 2012 7:49:09 AM UTC+5:30, NOORAIN ANSARI wrote: > > Dear Ashish, > > SAM is right, if you want to convert words to Numbers. > > Please see the attached file without using Macro (VBA Coding) > > > -- > Thanks & regards, > No

Re: $$Excel-Macros$$ How to Convert words in digits.

2012-07-17 Thread kumar.ashish861
Dear Sam, Thanks for the help. Thanks & Regards Ashish kumar On Monday, July 16, 2012 11:20:04 PM UTC+5:30, Sam Mathai Chacko wrote: > > Your question and title are contradicting. > > Do you want to convert words to numbers, or vice versa? > > Regards, > Sam Mathai Chacko > > On Mon, Jul 16, 2

Re: $$Excel-Macros$$ How to Convert words in digits.

2012-07-16 Thread Sam Mathai Chacko
Your question and title are contradicting. Do you want to convert words to numbers, or vice versa? Regards, Sam Mathai Chacko On Mon, Jul 16, 2012 at 11:15 PM, kumar.ashish861 wrote: > Dear All, > > Kindly help me to convert numbers in digits. I'll apply the formula > "spellnums" but, I think