The Accidental Decimal Problem in Excel
A highly confusing issue that occasionally affects Microsoft Excel users occurs when you type a whole number into a cell, but Excel automatically divides it by 100 and inserts a decimal point. For example, if you type “500”, Excel instantly changes it to “5.00”. This usually happens because a specific data entry feature was accidentally enabled, completely throwing off your financial calculations, inventory counts, or general data entry tasks.
Disabling the Automatic Decimal Point Feature
This behaviour is not a bug; it is a legacy feature designed to speed up manual data entry for accountants who type hundreds of prices without wanting to repeatedly press the decimal key. Fortunately, it is very easy to turn off.
1. Open Microsoft Excel.
2. Click on the File tab in the top-left corner of the application.
3. At the bottom of the left-hand menu, click on Options.
4. In the Excel Options dialog box, select the Advanced tab from the left-hand pane.
5. Look near the very top of the Advanced settings, under the “Editing options” section.
6. Locate the checkbox labelled Automatically insert a decimal point.
7. Untick this checkbox to disable the feature.
8. Click OK at the bottom of the window to save your changes.
Correcting Your Existing Data
It is important to understand that disabling this feature will not automatically fix the numbers you have already typed into your spreadsheet. Any numbers that were entered while the feature was active will remain stored as decimals (e.g., 5.00 instead of 500). To fix your existing data quickly, you can type the number 100 into a blank cell, copy that cell, highlight all the affected numbers, right-click, select Paste Special, choose Multiply, and click OK. This will instantly multiply all the selected decimals by 100, restoring them to their correct whole number format.