software

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. Editgt;Copy.

Select your quot;numbersquot;. Editgt;Paste Special, check Multiply.

Make a copy of your workbook before trying!

--
Kind regards,

Niek Otten

quot;bnkonequot; gt; wrote in message
...
gt;I have a sheet of 10K rows that have entries like this: 000345, 0034567,
gt; 0000067 etc. I am trying to do a vlookup on another table of 10K rows and
gt; join on the numbers. Unfortunately one of my source tables is missing the
gt; leading 0's with no hope of fixing it. Can anyone help me with a way to
gt; remove the leading 0's?
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-gt;Paste Special
Select Add
Click Okay

quot;bnkonequot; wrote:

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