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?

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?

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

"Pete_UK" wrote:

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?

On Fri, 19 Dec 2008 04:33:01 -0800, Tom wrote:

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