Calculation Issues

Fix Excel Automatic Decimal Places Changing 222 to 2.22

Emma BrownEmma Brown Nov 12, 2026 869 views

Question details

The user needs to stop Excel from automatically shifting decimal places in entered numbers.

Fix Excel Automatic Decimal Places Changing 222 to 2.22
Product
Microsoft Excel
Device & OS
not provided
Scenario
Numbers such as 222 are entered into a worksheet and should remain whole numbers.
Observed behavior
Excel displays entered values with an inserted decimal point, such as changing 222 to 2.22 or 10000 to 10.
Before you start

Check whether the affected cells use the General or Number format, then test the issue by entering a value in a blank cell. The automatic decimal setting affects newly entered values, so existing changed values must be corrected separately.

Solution 1Recommended

Turn off Automatically Insert a Decimal Point in Excel

Use this solution when Excel shifts the decimal position for every number you enter, such as displaying 222 as 2.22.

This behavior is usually caused by Excel's Automatically insert a decimal point editing option, not by the General cell format. Disabling the option stops Excel from applying a fixed decimal shift to future entries.

1
Open Excel Options

In Excel, select File > Options.

2
Open Advanced editing settings

In the Excel Options window, select Advanced in the left pane and locate the Editing options section.

3
Clear the automatic decimal option

Clear the Automatically insert a decimal point checkbox, then select OK to save the change.

4
Correct affected worksheet values

Re-enter values that were previously changed, or edit the affected cells directly in the formula bar to restore the intended numbers.

Turn off Automatically Insert a Decimal Point in Excel
Future entries keep their original value: After the option is cleared, entering 222 will display as 222 unless the cell itself has a different number format.
Free Microsoft Office alternative

Edit Spreadsheets Reliably with WPS Spreadsheet

If Microsoft Excel settings or organization policies prevent you from working as expected, WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open and edit existing Excel files seamlessly while using clear number-format controls for your worksheet data.

  1. 1. Download WPS Office: Select Download WPS Office Free and install WPS Office on your device.
  2. 2. Open the workbook in WPS Spreadsheet: Launch WPS Office, select Spreadsheets, then choose Open to open your Excel .xlsx or .xls file.
  3. 3. Check the number format: Select the affected cells, then use Home > Number Format to choose General or Number and confirm the intended decimal display.
Free and lightweight office suite for everyday spreadsheet workFamiliar spreadsheet tools and number-format controls for values and decimalsCompatible with Microsoft Excel .xlsx, .xls, and .csv filesOpen existing Excel workbooks and continue editing with a familiar ribbon-style interface
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel change 222 to 2.22 when I press Enter?

Excel may have Automatically insert a decimal point enabled with two decimal places configured. Go to File > Options > Advanced, clear Automatically insert a decimal point, and select OK.

Is the General format causing Excel to move my decimal point?

Usually no. The General format does not normally convert 222 to 2.22. This specific behavior is commonly caused by the Automatically insert a decimal point option under File > Options > Advanced.

Will turning off automatic decimal places fix numbers already changed?

No. The setting prevents future entries from being shifted, but values already entered must be retyped or corrected manually in the affected cells.

What if the Automatically insert a decimal point option is grayed out in Excel?

The setting may be controlled by an organization policy. Contact your IT administrator and ask whether the Excel editing option can be changed.