It could be your cell formating that is setup to display a set number of digets
Example to display 012345 when the true value in the cel is 12345 the cel would be formatted as 000000.

If changing the formatting does not work try Steel Monkey suggestion or this formula in a blank column


=MID(A1,2,LEN(A1-1))
The copy down

Change cell reference A1 as required

Once formula is entered use copy > Pastespecial > Values