Re: $$Excel-Macros$$ problem in code fpr data copied from text to number format

2015-02-03 Thread Ashish Bhalara
--- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >

Re: $$Excel-Macros$$ problem in code fpr data copied from text to number format

2015-02-03 Thread Paul Schreiner
you can, To all the people you can, As long as ever you can.” - John Wesley ----------------- From: Ashish Bhalara >To: excel-macros@googlegroups.com >Sent: Tuesday, February 3, 2015 1:02 AM >Subject: $$Excel-Macros$$ problem in code fpr data copied from text to

$$Excel-Macros$$ problem in code fpr data copied from text to number format

2015-02-02 Thread Ashish Bhalara
Dear experts, Please see attached file in which account no. field is text format but copied in number format. Problem is that when I type 0123, data copied at 123 as per my coding, I also try by define variable as string but problem same as standing. Please edit my code to solve this issue. Rega