View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default Number format in cell changes

Choose Format Cells , select Number type for all cells you are having trouble
with.

"Rubie" wrote:

Just recently, when typing a number in any cell of the spreadsheet the format
of the number typed changes. Example (3312 changes to 3.312E-297) when I
move to another cell.