Cannot Enter Desired Value

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
 
N

Niek Otten

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
 
Top