Fix Excel Automatic Decimal Places Changing 222 to 2.22
Question details
The user needs to stop Excel from automatically shifting decimal places in entered numbers.

- 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.
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.
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.
In Excel, select File > Options.
In the Excel Options window, select Advanced in the left pane and locate the Editing options section.
Clear the Automatically insert a decimal point checkbox, then select OK to save the change.
Re-enter values that were previously changed, or edit the affected cells directly in the formula bar to restore the intended numbers.

Ask Your Administrator if the Excel Setting Cannot Be Changed
Use this option when the decimal setting is unavailable, locked, or reset by a work or school policy.
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. Download WPS Office: Select Download WPS Office Free and install WPS Office on your device.
- 2. Open the workbook in WPS Spreadsheet: Launch WPS Office, select Spreadsheets, then choose Open to open your Excel .xlsx or .xls file.
- 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.

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.




