HOW DO I STOP AUTOMATIC SCIENTIFIC NOTATION IN A CELL

[Guest]

When entering a part number such as 419E1 the cell defaults to scientific and
displays - 4190 - unless I use a ' before this kind of part number. If I
re-enter a normal number after that, the cell remains in the scientific mode.

 

[Guest]

format the cell as number prior to entering the first piece of data
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[Bob Umlas]

Either use that apostrophe, or pre-format the cell(s) as Text.
The nature of the beast.
Bob Umlas
Excel MVP

When entering a part number such as 419E1 the cell defaults to scientific and
displays - 4190 - unless I use a ' before this kind of part number. If I
re-enter a normal number after that, the cell remains in the scientific

mode.