remove irregular count of 0 from a list of numbers

I have a list of 10000 rows with numbers with either 4,5,6,7 or 8 leadign zeros. All numbers are always 14 digit long. Is there any way to remove all the leading zeros through a formula without going through each and every one of them?

Thank you,

Jay