How do I change the default number format in excel?

C

chipster

Somehow, my excel settings were changed. Now, when I enter a number without
including a decimal, excel automatically adds one. For example, if I enter
1200 it shows as 12.00 instead of 1200. I want to enter numbers without
using the decimal point.
 
G

Gord Dibben

chipster

Tools>Options>Edit. Uncheck "fixed decimal places".


Gord Dibben Excel MVP
 
Top