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
 
Back
Top