View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default default format for Excel numbers

Goto the menu ToolsOptionsEdit tabuncheck Fixed decimal placesOK

--
Biff
Microsoft Excel MVP


"Chuck G" <Chuck wrote in message
...
Bringing up a new sheet and typin in the number 262 in any cell, gets
entered
as 2.62; as if the entered nuymber is divided by 100. How do I change it
back
to normal?