How do I eliminate leading zeros from downloaded data?

I have downloaded data from another source and the customer numbers are of
different numeric lengths (ex- 345 and 34567). Excel preceeded the numbers
with zeros to make the character length equal to 8. How to I drop the
preceeding zeros?

Thanks!