Calculation Issues

How to Fix Excel Decimal Points Disappearing When Editing Cells

Maira Mehtab Sep 27, 2026 870 views

Question details

Users experience an issue where Excel automatically removes the decimal point from numbers after a cell is edited, unexpectedly altering the intended value.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Editing existing cells that contain numeric data with decimal values.
Observed behavior: The decimal point disappears immediately after the user finishes editing the cell, converting the decimal number into a much larger integer (for example, 1.456 changes to 1456).

Before you start

Confirm whether the issue occurs in all Excel workbooks or just a specific file, and check that the affected cells are not using a custom number format that intentionally hides decimals.

Solution 1Recommended

Disable the 'Automatically Insert a Decimal Point' Feature

This built-in Excel feature can override manual decimal entries and incorrectly format numbers when you edit existing cells.

When the automatic decimal insertion feature is enabled, Excel attempts to guess where the decimal belongs based on fixed rules, which often conflicts with manually typed decimals.

Open Excel Options

Click on the 'File' tab in the top-left corner of Excel and select 'Options' from the bottom of the menu.

Navigate to Advanced Settings

In the Excel Options dialog box, click on 'Advanced' in the left-hand navigation pane.

Disable Automatic Decimals

Under the 'Editing options' section at the top, locate and uncheck the box labeled 'Automatically insert a decimal point'.

Save Changes

Click the 'OK' button to apply the changes, then return to your worksheet to test editing a decimal number.

Check Complete: Once disabled, Excel will accept exactly what you type without attempting to shift the decimal places automatically.

Solution 2

Verify Regional Separator Settings in Excel and Windows

Conflicting decimal and thousands separators between your Windows region settings and Excel can cause decimal points to vanish.

Accurate Spreadsheet Software

Use WPS Spreadsheet for Precise Data Entry

If Excel settings continue to alter your numeric data, WPS Spreadsheet offers an intuitive and reliable environment where cell formatting and decimal values remain exactly as you enter them.

1. Open Your Spreadsheet in WPS Office: Launch WPS Spreadsheet and open the file containing your numeric data.
2. Access Cell Formatting: Highlight the affected cells, right-click, and choose 'Format Cells' from the context menu.
3. Define Decimal Precision: Under the 'Number' tab, select 'Number' from the category list and explicitly set your desired number of decimal places.
4. Verify Editing Options: Click 'Menu' > 'Options' > 'Edit' to confirm that manual data entry settings are properly configured for your workflow.

Ensure accurate numeric data entry without unexpected decimal shifts.Fully compatible with Microsoft Excel (.xlsx and .xls) file formats.Easily manage decimal places and cell formatting with a user-friendly interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel change my decimal like 1.5 to 15?

This usually happens when the 'Automatically insert a decimal point' feature is enabled in Excel's Advanced options. When enabled, Excel automatically moves the decimal place based on a set number of digits, which overrides your manual entry.

Does changing the cell format fix disappearing decimals?

Applying a strict Number format via 'Format Cells' can sometimes force decimals to display, but if the 'Automatically insert a decimal point' setting is active, the underlying value entered into the cell will still be mathematically altered during editing.

How do I fix comma and period confusion in Excel?

You can resolve separator confusion by navigating to File > Options > Advanced in Excel. Ensure the 'Use system separators' option is checked so Excel matches your Windows Region settings, or uncheck it to manually assign the period as the decimal separator.

Excel & Data Problems