How to Reset Excel Default Number Format from Accounting to General
Question details
The user needs to revert Excel's default number format back to General, as every new workbook automatically applies the Accounting format to all cells.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a new blank Excel workbook or entering numbers into cells.
- Observed behavior
- Numbers are automatically formatted as Accounting instead of the standard General format, likely due to altered template settings or company policies.
Close all active Excel workbooks and ensure you have administrative permissions or access to your computer's hidden AppData system folders.
Delete or Modify the Custom Template in the XLSTART Folder
Removing a modified Book.xltx file from Excel's startup folder forces the program to recreate the default General format for new files.
Excel uses files stored in the XLSTART folder as the basis for new workbooks. If a template within this folder has been set to default to the Accounting format, all new spreadsheets you create will inherit this setting. Deleting it allows Excel to restore factory defaults.
Ensure Microsoft Excel is completely closed before attempting to modify startup files.
Open File Explorer and navigate to the following path: C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\XLSTART. You may need to enable 'Hidden items' in the View tab to see the AppData folder.
Look for a file named Book.xltx or Sheet.xltx. Delete these files, or move them to your desktop as a backup.
Open a new blank workbook in Excel. The default number format should now correctly display as General.

Launch Excel in Safe Mode to Isolate Add-ins
Safe mode disables third-party add-ins that might be forcing the Accounting format on your cells.
Review Windows Regional and Currency Settings
Sometimes system-wide regional settings can interfere with how Excel interprets default currency and accounting formats.
Use WPS Office as a Free, Hassle-Free Spreadsheet Alternative
If your Excel settings are locked by company policy or persistent bugs keep changing your number formats to Accounting, try WPS Office. WPS Spreadsheet provides a lightweight, highly compatible alternative with easy-to-manage default formats.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package.
- 2. Install and Launch: Run the installer, open WPS Spreadsheet, and create a new blank workbook.
- 3. Enjoy Default Formatting: Start typing your data immediately with the correct General number format natively applied.

Frequently Asked Questions
Why does Excel keep defaulting to Accounting format?
This usually happens when the default template (Book.xltx) in Excel's XLSTART folder has been modified to use the Accounting format, or due to a restrictive company-managed IT policy.
Where is the XLSTART folder located?
The default path is typically C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\XLSTART, though it may vary slightly depending on your specific Office version and installation.
Can a macro change my default number format?
Yes. If you have an active macro stored in your Personal Macro Workbook (Personal.xlsb) that applies Accounting formats to new sheets upon opening, it will override the General default.
How do I temporarily change the format for a single workbook?
Select all cells by pressing Ctrl+A, go to the Home tab on the ribbon, and select 'General' from the Number Format dropdown menu.




