View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
flish flish is offline
external usenet poster
 
Posts: 4
Default Cell changes from General format to Scientific

Entered 123E305 in a cell having the format of General. It returns 1.23E+307
and changes the cell format to Scientfic.

Entered 123E306 in a cell having the format of General. It returns 123E306
and retains the General formatting.

What would cause this?

Thanks