Fixed Decimal Places

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.

FixedDec

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.

One thought on “Fixed Decimal Places


Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.