Format the cells as Number with zero decimal places. Ensure that the
column is wide enough to show all 12 digits.

Hope this helps.

Pete

On Dec 19, 11:06*am, Tom wrote:
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?