Daily Dose of Excel

If you find that Excel is dividing your input by 100 for no apparent reason, it’s probably because you have checked “Fixed Decimal Places” under Tools>Options>Edit.

Uncheck that box to return to normal behavior. Of course it doesn’t have to be 100, it’s just that Excel defaults to 2 decimal places when that box is checked.