Entering numerical figures into Microsoft Excel should capture the exact digits you type. However, many users suddenly discover that entering a whole number such as 500 instantly morphs into 5.00, or typing 25 converts into 0.25. This irritating behaviour causes confusion and disrupts financial calculations. Fortunately, this is not a formula glitch or workbook corruption—it is an intentional legacy feature called Fixed Decimals that has been inadvertently activated in application options.
Why Excel Inserts Unwanted Decimal Points Automatically
Unlike standard cell number formatting (which merely alters how a stored number is displayed visually), Excel possesses a global input mechanism that divides raw input entries upon keystroke confirmation:
- Automatically insert a decimal point: An advanced Excel preference specifically created for rapid ten-key data entry. When enabled with two places, typing numbers assumes cents or pence without pressing the period key.
- Cell-level custom number formatting: Formats containing
%or scaling commas can visually scale values down by a factor of 100 or 1,000 without altering the underlying entry. - Keyboard layout regional settings: Regional mismatches between comma and period separators can lead to unexpected interpretation of number sequences.
1. Disable the “Automatically Insert a Decimal Point” Setting
Disabling this global preference restores normal numerical typing behaviour across all workbooks immediately.
- Open Microsoft Excel.
- Click on File in the top-left ribbon corner and select Options at the bottom of the navigation bar.
- In the Excel Options dialogue window, click on Advanced in the left pane.
- Under the very first section labelled Editing options, locate Automatically insert a decimal point.
- Untick the checkbox beside Automatically insert a decimal point.
- Click OK at the bottom of the window to confirm your changes.
- Click on any cell in your spreadsheet and type a number to confirm that whole numbers remain whole.
2. Correct Already Entered Numbers Using Paste Special
Turning off the fixed decimal setting prevents future entries from dividing by 100, but existing figures in your spreadsheet will retain their reduced values (e.g. 5.00 instead of 500). You can restore them to whole numbers instantaneously without manual retyping:
- Click an empty cell anywhere on the sheet and type the number
100. - Press Ctrl + C to copy this cell to your clipboard.
- Highlight the entire range of numbers that were improperly divided.
- Right-click within the selected range and choose Paste Special (or press Ctrl + Alt + V).
- In the Paste Special dialogue box, under the Operation section, select Multiply.
- Click OK. Excel will multiply every selected figure by 100, instantly restoring the correct whole values.
- Delete the number 100 from the temporary cell you used.
3. Verify Cell Number Formatting
If the Advanced Option was already unticked, check whether the affected cells are formatted with an unintentional percentage or custom mask.
- Highlight the cells displaying unexpected decimal values.
- On the Home tab, review the Number Format dropdown in the Number group.
- If it displays Percentage, Accounting, or Custom, switch it back to General or Number.
- Use the Decrease Decimal button on the ribbon to remove any lingering zero decimal places if whole integer presentation is required.