I have a series of part numbers in an excel spreadsheet
They should be 12 digit numbers
however some of the numbers are displaying , apparently at random, in
scientific notation as exponents. If I click on the number in question it
displays normally in the formula bar but the cell is scientific notation. I
have formatted the whole column and it still seems to happen at intervals.

Any suggestions?