clearing zeros

[H Williams]

I currently convert files into excel from another
program. I have certain data elements that consist of 6
digits but zeros precede the numbers if it's less than 6
full digits i.e 4207 appears as 004207. I need to know
how to delete these zeros so that the data in the cell
appears as 4207. If I click on each cell individually it
works but I need to know how to do it for an entire
column.

 

[YAN]

can you try to go to Format --> cells -- > number

 

[Jason Morin]

=MID(A1,MIN(IF(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)
<>"0",ROW(INDIRECT("1:"&LEN(A1))))),255)

Insert this, press <Ctrl><Shift><Enter>, and fill down the
column.

HTH
Jason
Atlanta, GA