Office Settings & Configuration

How to Stop Excel from Automatically Changing 1 to 0.01

Huma Ashraf Ch Sep 30, 2026 868 views

Question details

The user needs to prevent Excel from automatically converting whole numbers into decimal values during data entry.

How to Stop Excel from Automatically Changing 1 to 0.01

Product: Microsoft Excel
Device & OS: not provided
Scenario: Typing whole numbers into a spreadsheet cell for basic data entry.
Observed behavior: Entering the number 1 results in 0.01 appearing in the formula bar, and often displays as 0 in the worksheet depending on cell formatting.

Before you start

Verify whether this issue happens in all your Excel workbooks or just a specific one, as this will confirm if you are dealing with a global application setting rather than a cell-specific formatting rule.

Solution 1Recommended

Disable the Automatically Insert a Decimal Point Setting

Turn off the advanced editing feature that automatically divides entered numbers by a set decimal place value.

Excel includes a specialized feature designed to speed up manual data entry for accountants by automatically inserting decimal points. When this feature is enabled and set to 2 decimal places, any whole number you type is automatically divided by 100. Disabling this global setting restores normal typing behavior.

Open Excel Options

Click on the 'File' tab in the top-left corner of the Excel ribbon, then select 'Options' at the very bottom of the left-hand menu.

Navigate to Advanced Settings

In the Excel Options dialog box that appears, click on the 'Advanced' tab located in the left pane.

Locate Editing Options

Look at the very first section at the top of the right pane, labeled 'Editing options'.

Uncheck the Decimal Setting

Find the checkbox for 'Automatically insert a decimal point' and click to uncheck it. Alternatively, you can leave it checked and change the 'Places' value to 0.

Apply and Save

Click the 'OK' button at the bottom of the window to apply your changes. New numbers you type will now display exactly as entered.

Disable the Automatically Insert a Decimal Point Setting

Applies to New Entries Only: This fix immediately applies to any new numbers you type. However, it will not retroactively correct numbers that were already converted to 0.01; you will need to re-enter or multiply those existing values by 100.

Data Entry Efficiency

Easily Manage Data Entry Settings with WPS Office

WPS Spreadsheet offers a clean, highly compatible, and intuitive interface for all your data entry needs. You can easily manage automatic decimal settings to ensure your numbers behave predictably and exactly as you type them.

1. Open WPS Spreadsheet: Launch WPS Office and open your spreadsheet document.
2. Access the Options Menu: Click on the 'Menu' button in the top-left corner and select 'Options' from the drop-down list.
3. Go to Edit Settings: In the Options window, select the 'Edit' tab from the left-hand side menu.
4. Disable Automatic Decimals: Find the 'Provide automatic decimalization' setting and uncheck the box to disable it.
5. Confirm Changes: Click 'OK' to save your preferences and resume accurate data entry.

Fully compatible with Microsoft Excel (.xlsx) formatsEasily toggle automatic decimal placement and editing rulesFree, lightweight, and fast-loading office suiteFamiliar interface makes migration seamless with zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Will disabling this setting fix the numbers I already typed?

No, changing the automatic decimal point setting only applies to new data entered after the setting is changed. To fix existing data, you can type 100 in an empty cell, copy it, select the incorrect numbers, use 'Paste Special', and choose 'Multiply'.

Why does Excel sometimes change my numbers into dates?

This happens when the cell format is accidentally set to 'Date' instead of 'General' or 'Number'. To fix it, select the affected cells, go to the Home tab, click the Number Format drop-down menu, and select 'General'.

Can I keep the automatic decimal feature but change where the point goes?

Yes. If you prefer to keep the feature on but need a different decimal placement (e.g., dividing by 10 instead of 100), you can adjust the 'Places' number located directly below the 'Automatically insert a decimal point' checkbox in Advanced Options.

Office App Problems