Calculation Issues

Fix Excel Changing 10000 to 100 After Deleting a Macro

Anum MushtaqAnum Mushtaq Nov 14, 2026 869 views

Question details

The user wants Excel to stop shifting the decimal point when whole numbers are entered.

Product
Microsoft Excel
Device & OS
not provided
Scenario
Entering whole numbers in Excel after using and deleting a macro.
Observed behavior
Entering 10000 produces 100, and the behavior continues after Office is reinstalled.
Before you start

Open Excel and check whether the same decimal shift occurs in a blank worksheet. Note how many places the decimal point moves so you can compare it with the setting.

Solution 1Recommended

Turn Off Automatic Decimal Point Insertion in Excel

Use this setting when Excel shifts decimal points as you enter numbers.

1
Open Excel options

In Excel, select File > Options.

2
Find the editing setting

Select Advanced and look under Editing options for Automatically insert a decimal point.

3
Disable the setting

Clear the Automatically insert a decimal point checkbox, then select OK.

4
Test a new entry

Select an empty cell, enter 10000, and press Enter. The cell should now show 10000.

Turn Off Automatic Decimal Point Insertion in Excel
Previously entered values: Turning off the setting affects new entries; it does not automatically correct values already entered. Check affected cells and reenter their intended values if needed.
Free Microsoft Office alternative

Work with Excel Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets for an easy transition, although it does not change Excel's decimal point setting.

Enter and edit numbers in a familiar spreadsheet interfaceCompatible with Microsoft Excel XLS and XLSX formatsFree and lightweight for everyday spreadsheet workOpen existing spreadsheets to help make the transition seamless
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel change 10000 to 100?

The Automatically insert a decimal point setting may be enabled with two decimal places. Check File > Options > Advanced under Editing options.

Will disabling automatic decimal insertion fix existing cells?

No. The change applies to new entries. Check affected cells and reenter the intended numbers where necessary.

Why did deleting the macro or reinstalling Office not fix the issue?

The decimal shift can be caused by an Excel setting rather than a macro that is still present. Check File > Options > Advanced and clear Automatically insert a decimal point.

What if 10000 still appears as 100 after I turn off the setting?

Test a new entry in a blank worksheet. If the problem remains, select the cell and inspect its number format on the Home tab; also check whether other macros or workbook-specific behavior are changing entries.