Try this:

Format an empty cell as Number. Enter the number 1. EditCopy.

Select your "numbers". EditPaste Special, check Multiply.

Make a copy of your workbook before trying!

--
Kind regards,

Niek Otten

"bnkone" wrote in message
...
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?