Strip away leading zeros

S

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!!
 
T

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
 
E

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top