remove irregular count of 0 from a list of numbers

**sa02000** · 04-12-2011, 01:01 PM

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

**ChemistB** · 04-12-2011, 01:09 PM

A number of possibilities. Try this
Select the column, go to "Text to Columns"
Click on Finish
Does that work?

**martindwilson** · 04-12-2011, 02:43 PM

if they are showing leading 0 they are probably text so put a 0 in a spare cell copy select your column paste special add

**sa02000** · 04-12-2011, 07:49 PM

Thank you very much for your help. I realized that if there are leading zeros that means its text. So multiplying by 1 fixed it. Also, I tried adding leading zeros to my other list that I was comparing the list with leading zeros with and that worked well too.

Thanks again everyone for your help.

Jay