Strip away leading zeros

[Sergei]

I have a text field, in which data looks like this:

000001486
001674600
000000078

I want to strip away the leading zeros and convert these to numbers. Please
advise how I could do that...

Thank you!!

 

[Luke M]

=VALUE(A2)

Copy down as needed.

 

[T. Valko]

Sometimes this will do it...

Select the range of cells you want to convert.
Goto the menu Data>Text to Columns
Click Finish

 

[Elkar]

Or, if you just want to convert the numbers without ending up with a second
column of data, try this:

Enter a 1 into any blank cell
Copy that cell
Select your range of data
Right-click and select "Paste Special..."
Check the "Multiply" option
Click OK
Delete the 1 you entered originally

HTH
Elkar