Cannot Enter Desired Value

  • Thread starter Thread starter myrrh
  • Start date Start date
M

myrrh

When I enter a number (229.65) then hit "enter" or "tab", I ge
"2.30E+02". What the heck is that and how do I turn it off
 
You probably accidentally formatted your cell as Scienfific.
Remedy: Format>Cells>Number>General, or some other standard or custom
format.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top