Removing leading 0s

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sheet of 10K+ rows that have entries like this: 000345, 0034567,
0000067 etc. I am trying to do a vlookup on another table of +10K rows and
join on the numbers. Unfortunately one of my source tables is missing the
leading 0's with no hope of fixing it. Can anyone help me with a way to
remove the leading 0's?
 
Try this:

Format an empty cell as Number. Enter the number 1. Edit>Copy.

Select your "numbers". Edit>Paste Special, check Multiply.

Make a copy of your workbook before trying!
 
If they are missing, why do you need to remove them? They are probably
formatted as text. Follow this procedure to change to remove the zeros.

Copy a blank cell.
Select the cells you want to remove the zeros (you can select a whole
column; it will ignore the blank cells).
Select Edit->Paste Special
Select Add
Click Okay
 

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

Similar Threads

how do I eliminate leading "0s" in an alpha numeric cell 1
Show leading 0s for binary formatted cell? 1
Pivot Table 1
Leading zeros 9
Removing leading and trailing space... 2
Removing leading 0s 1
Array formula to Identify Leading Zeros. 2
Removing leading zeros from a group of numbers 3

Back
Top