How to Fix Excel Entering 9 as 0.09 (Stop Automatic Decimals)
Question details
The user types a whole number like 9 into a cell, but the application automatically converts it into a decimal value like 0.09.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Manually entering numerical data into spreadsheet cells
- Observed behavior
- Numbers are automatically divided by 100 as a decimal point is inserted by default, altering the intended inputted whole number.
Check if this issue occurs in all Excel files or just a specific one. The automatic decimal insertion is an application-level setting, meaning it will affect every workbook you open on this device until it is turned off.
Disable the 'Automatically insert a decimal point' Setting
Turn off the built-in editing option that forces Excel to place decimal points in typed numbers.
Excel has a feature designed to speed up data entry for accounting or financial tasks by automatically placing a decimal point. When this is accidentally enabled with a default place value of 2, any whole number you type will be divided by 100.
Launch Microsoft Excel and click on the 'File' tab in the top-left corner. Scroll down to the bottom of the left-hand menu and select 'Options'.
In the Excel Options dialog box that appears, click on 'Advanced' in the left pane to access advanced program settings.
Look under the 'Editing options' section at the very top. Find the checkbox labeled 'Automatically insert a decimal point' and clear it (uncheck the box).
Click 'OK' at the bottom of the window to apply your changes. Type the number 9 into a blank cell to confirm it now displays as 9 instead of 0.09.

Manage Data Entry Settings Easily with WPS Spreadsheet
If you are looking for a reliable and lightweight alternative for your daily data management, WPS Spreadsheet offers an intuitive interface where editing options are easy to find and control.
- 1. Open Options: In WPS Spreadsheet, click the 'Menu' button in the top-left corner and select 'Options' from the drop-down list.
- 2. Navigate to Edit Settings: Select the 'Edit' tab from the left-hand panel of the Options window.
- 3. Disable Automatic Decimals: Uncheck the box next to 'Automatically insert a decimal point' and click 'OK' to save your preferences.

Frequently Asked Questions
Why did Excel start changing my numbers to decimals automatically?
This typically happens if the 'Automatically insert a decimal point' setting was accidentally toggled on, or if a third-party add-in or macro temporarily modified your default editing preferences.
Will disabling this setting fix the numbers I have already entered?
No, turning off the automatic decimal point setting only applies to future data entry. To fix numbers already converted to 0.09, you can type 100 in an empty cell, copy it, select your affected cells, use 'Paste Special', and choose 'Multiply'.
Can I set a specific number of decimal places instead of completely turning it off?
Yes. If you keep the 'Automatically insert a decimal point' box checked, you can adjust the 'Places' value. Entering a positive number determines the decimal places, while entering a negative number (e.g., -3) will add zeros to your number (typing 9 becomes 9000).
Does this setting affect all my Excel files?
Yes, this is an application-level setting. Once you enable or disable it, the behavior will apply to all existing and new workbooks opened in that specific Excel installation on your computer.




