Stop Excel From Changing Entered Numbers to Decimals
Question details
The user needs to stop Excel from automatically placing a decimal point in numbers entered into cells.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user enters whole numbers such as 120 or 1 into a worksheet and wants the values to remain unchanged.
- Observed behavior
- Excel converts 120 to 1.2 and 1 to 0.01, even after the cell number format is changed.
This behavior is controlled by an Excel editing option rather than the cell format. Check a new blank cell after changing the setting, because existing converted values may need to be corrected manually.
Disable Automatically Insert a Decimal Point in Excel
Use this solution when Excel shifts the decimal point every time you enter a number, such as changing 120 to 1.2.
Excel can apply a fixed number of decimal places while you type. Turning off this editing option prevents Excel from automatically dividing newly entered numbers by powers of 10.
In Excel, select File > Options.
Select Advanced in the left pane, then find the Editing options section.
Clear the Automatically insert a decimal point check box. If a Places value is shown, it no longer applies after the check box is cleared.
Click OK, then select a blank cell and enter a number such as 120 to confirm that it remains 120.

Edit Excel Workbooks Easily with WPS Spreadsheet
If you want a free, lightweight spreadsheet application with a familiar interface, WPS Office provides a smooth alternative for opening, editing, and migrating Microsoft Excel workbooks. WPS Spreadsheet supports common spreadsheet formatting and number-entry tasks while maintaining compatibility with Excel files.

Frequently Asked Questions
Why does Excel change 120 into 1.2 when I type it?
The Automatically insert a decimal point option is enabled. Excel applies the configured number of decimal places during data entry, causing 120 to be displayed as 1.2 when two decimal places are inserted.
Why does changing the cell format not stop the decimal shift?
Cell formatting controls how a value is displayed, but the automatic decimal setting changes the value as it is entered. Go to File > Options > Advanced and clear Automatically insert a decimal point.
Will disabling the automatic decimal point fix numbers already entered?
No. The change applies to future entries. Review existing cells and manually correct them, or use a formula such as =A1*100 when values were shifted two decimal places.
Where is the Automatically insert a decimal point setting in Excel?
Open File > Options > Advanced. Under Editing options, clear the Automatically insert a decimal point check box and select OK.




