M myrrh Feb 23, 2004 #1 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
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 Feb 23, 2004 #2 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
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