Fix Excel Changing 10000 to 100 After Deleting a Macro
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.
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.
Turn Off Automatic Decimal Point Insertion in Excel
Use this setting when Excel shifts decimal points as you enter numbers.
In Excel, select File > Options.
Select Advanced and look under Editing options for Automatically insert a decimal point.
Clear the Automatically insert a decimal point checkbox, then select OK.
Select an empty cell, enter 10000, and press Enter. The cell should now show 10000.

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.

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.




