If all numbers are the same number of chaacters you could use the
following formula to get rid of the 0's

If 01234500 is in cell A1 then in cell B1 enter =MID(A1,1,6) where 1 is
the number of the first character to include and 6 is the number of
characters to include, so in this example it would return the value
012345

Paul


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=391238