Re: Number Formatting help

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 <T...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I have a series of part numbers in an excel spread***
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?


.

Quantcast