Formatting Issues

Stop Excel From Changing Entered Numbers to Decimals

John WilsonJohn Wilson Nov 12, 2026 870 views

Question details

The user needs to stop Excel from automatically placing a decimal point in numbers entered into cells.

Stop Excel From Changing Entered Numbers to Decimals
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel Options

In Excel, select File > Options.

2
Open Advanced editing settings

Select Advanced in the left pane, then find the Editing options section.

3
Clear the automatic decimal setting

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.

4
Confirm and test the change

Click OK, then select a blank cell and enter a number such as 120 to confirm that it remains 120.

Disable Automatically Insert a Decimal Point in Excel
Correct existing entries if needed: Disabling the option affects new entries. Values that were already changed, such as 1.2 instead of 120, must be edited or multiplied by the appropriate factor.
Free Microsoft Office alternative

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.

Free and lightweight spreadsheet software for everyday data entry and formattingOpen, edit, and save Microsoft Excel .xlsx and .xls filesUse a familiar ribbon-style interface for a seamless transition from ExcelManage cell number formats and worksheet calculations with WPS Spreadsheet
microsoft office alternative - wps office

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.