Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
number formatting | Excel Discussion (Misc queries) | |||
formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
number formatting | Excel Discussion (Misc queries) | |||
Number Formatting | Excel Worksheet Functions | |||
Number Formatting | Excel Discussion (Misc queries) |