Pulling data out of a cell

[lwilt]

I'm trying to pull a chunk of data out of a cell but in each cell the league of the data coming out is different. It would look like:


0000905

0001845

0000845

0032609


I want to get everything after the zeros where the real number starts but can't figure out how to do it since there will be zeros within some of the numbers. I've tried formatting the numbers to remove the zeros but that didn't work either.

 

[Faseeh]

Hi Iwilt,


I think you can use following to convert text to numbers:

=TEXT(A1,"#")

Regards,

 

[NARAYANK991]

Hi Wilt ,


An alternative is to use the formula =A1+0


In case you don't wish to use an additional column or cells with formulae , then you can do a copy + paste special as follows :


1. Enter the number 1 in any unused cell , say AB1


2. Place the cursor in this cell , AB1 , and press CTRL C ( to copy )


3. Select the range of cells where you have the numbers with leading zeroes.


4. Right click , and select Paste Special , Multiply , OK.


Narayan


Narayan

 

[SirJB7]

Hi, lwilt!

Third option:

=VALUE(A1)

Regards!