Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-07 Thread 'Keisha Fry' via MS EXCEL AND VBA MACROS
On Fri, 4/7/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 10

Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-07 Thread 'Martin George' via MS EXCEL AND VBA MACROS
On Fri, 4/7/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 10

Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-07 Thread 'Margareta Tolliver' via MS EXCEL AND VBA MACROS
On Fri, 4/7/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 10

Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-07 Thread 'Margareta Tolliver' via MS EXCEL AND VBA MACROS
On Fri, 4/7/17, 'Keisha Fry' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 8

Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-07 Thread 'Keisha Fry' via MS EXCEL AND VBA MACROS
On Fri, 4/7/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 3

Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-07 Thread 'Liberty Stringer' via MS EXCEL AND VBA MACROS
On Fri, 4/7/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 9

Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-07 Thread Deepu Dubey
Hi Please review and do let me know if anything else required. Regards DD On Thu, Apr 6, 2017 at 3:09 PM, Secret Shot wrote: > Hi Experts, > > I am stuck with one problem. I have one file which have numbers in it. but > while capturing they got stored as Text. > > Now i

Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-07 Thread Deepu Dubey
Hi, Please review and revert if anything else required. Regards DD On Thu, Apr 6, 2017 at 3:09 PM, Secret Shot wrote: > Hi Experts, > > I am stuck with one problem. I have one file which have numbers in it. but > while capturing they got stored as Text. > > Now i want

Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-07 Thread 'Julienne Schindler' via MS EXCEL AND VBA MACROS
On Fri, 4/7/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 9

Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-07 Thread 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
On Fri, 4/7/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 4

Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-06 Thread 'Julienne Schindler' via MS EXCEL AND VBA MACROS
On Thu, 4/6/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Thursday, April 6, 2017, 6

Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-06 Thread 'Carmelita Cronin' via MS EXCEL AND VBA MACROS
On Thu, 4/6/17, 'Martin George' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Thursday, April 6, 2017, 6

Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-06 Thread 'Martin George' via MS EXCEL AND VBA MACROS
On Thu, 4/6/17, jmothilal <gjmothi...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Thursday, April 6, 2017, 1:36 PM first letter is not zero  is "O&q

Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-06 Thread Saleem Ansari
Dear Pankaj G, Please check your solved query. if any issue , let me know. On Thu, Apr 6, 2017 at 3:09 PM, Secret Shot wrote: > Hi Experts, > > I am stuck with one problem. I have one file which have numbers in it. but > while capturing they got stored as Text. > > Now i

Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-06 Thread jmothilal
first letter is not zero is "O" , so Remove the first letter "O", On Thu, Apr 6, 2017 at 3:09 PM, Secret Shot wrote: > Hi Experts, > > I am stuck with one problem. I have one file which have numbers in it. but > while capturing they got stored as Text. > > Now i want any

$$Excel-Macros$$ Formula to convert Text into Number

2017-04-06 Thread Secret Shot
Hi Experts, I am stuck with one problem. I have one file which have numbers in it. but while capturing they got stored as Text. Now i want any formula to convert into normal Text. also there look like another space in the cell but when i try to remove it backspace, last digit of number got