clearing zeros

  • Thread starter Thread starter H Williams
  • Start date Start date
H

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.
 
=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
 
Back
Top