Calculation Issues

How to Fix Excel Entering 9 as 0.09 (Stop Automatic Decimals)

Ayan MasoodAyan Masood Oct 23, 2026 869 views

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.

How to Stop Excel from Automatically Inserting Decimal Points
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel Options

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'.

2
Navigate to Advanced Settings

In the Excel Options dialog box that appears, click on 'Advanced' in the left pane to access advanced program settings.

3
Clear the Decimal Setting

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).

4
Save and Verify

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.

Disable the 'Automatically insert a decimal point' Setting
Settings Applied: Any new numbers you enter will now display exactly as typed. Note that this will not automatically convert previously entered decimals back to whole numbers.
Try WPS Spreadsheet

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. 1. Open Options: In WPS Spreadsheet, click the 'Menu' button in the top-left corner and select 'Options' from the drop-down list.
  2. 2. Navigate to Edit Settings: Select the 'Edit' tab from the left-hand panel of the Options window.
  3. 3. Disable Automatic Decimals: Uncheck the box next to 'Automatically insert a decimal point' and click 'OK' to save your preferences.
Completely free and lightweight office suiteSeamlessly compatible with Microsoft Excel (.xlsx) file formatsIntuitive settings menu prevents accidental configuration changesFamiliar user interface ensuring zero learning curve
microsoft office alternative - wps office

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.