View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
crankyhank crankyhank is offline
external usenet poster
 
Posts: 1
Default HOW DO I STOP AUTOMATIC SCIENTIFIC NOTATION IN A CELL

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.