Re: $$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING

2015-08-28 Thread SUDHIR VERMA
thanks to both of your for prompt support. On 29 August 2015 at 01:03, Haroon Rasheed wrote: > *There are many methods and ways to convert text into numbers try below on > the whole column will help you in a sec.* > > > > Use the Paste Special Command > > To use the *Paste Special* command, foll

RE: $$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING

2015-08-28 Thread Haroon Rasheed
There are many methods and ways to convert text into numbers try below on the whole column will help you in a sec. Use the Paste Special Command To use the Paste Special command, follow these steps: 1. In any blank cell, type the value 1. 2. Make sure the cell you typed 1 in is form

Re: $$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING

2015-08-27 Thread Prafull Jadhav
​select that column -Text to Column ( in Data Tab) -Click Finish ​ Regards, Prafull Jadhav 9920553518 On 27 August 2015 at 18:49, SUDHIR VERMA wrote: > Dear Friends, > Please help me as per attached sheet. I have data of 25k row. there are > some code formatting as text. So you are request to