Office Settings & Configuration

How to Reset Excel Default Number Format from Accounting to General

Khadija KhanKhadija Khan Nov 3, 2026 869 views

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.

How to Reset Excel's Default Number Format from Accounting to General
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.
Before you start

Close all active Excel workbooks and ensure you have administrative permissions or access to your computer's hidden AppData system folders.

Solution 1Recommended

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.

1
Close Excel

Ensure Microsoft Excel is completely closed before attempting to modify startup files.

2
Navigate to XLSTART

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.

3
Remove the Custom Template

Look for a file named Book.xltx or Sheet.xltx. Delete these files, or move them to your desktop as a backup.

4
Restart Excel

Open a new blank workbook in Excel. The default number format should now correctly display as General.

Delete or Modify the Custom Template in the XLSTART Folder
Work Computers: If you cannot access the AppData or XLSTART folders on a company laptop, the configuration may be managed by an organizational policy. You will need to contact your IT department to adjust this setting.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website and download the free installation package.
  2. 2. Install and Launch: Run the installer, open WPS Spreadsheet, and create a new blank workbook.
  3. 3. Enjoy Default Formatting: Start typing your data immediately with the correct General number format natively applied.
Fully compatible with Microsoft Excel (.xlsx, .xls) file formats.No complicated XLSTART folders—default cell formats remain exactly as General.Lightweight and free to use without mandatory subscription fees.Familiar user interface makes transitioning from Microsoft Office seamless.
microsoft office alternative - wps office

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.