Number Formatting help

[Tom]

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?

 

[Pete_UK]

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

 

[Tom]

I had already tried that solution but it keeps reverting even though the
entire column is formatted that way and it is more than wide enough. Thanks
anyway

 

[Ron Rosenfeld]

I had already tried that solution but it keeps reverting even though the
entire column is formatted that way and it is more than wide enough. Thanks
anyway

Tom,

Try the custom format of "000000000000"
--ron