How to Stop Excel from Automatically Formatting Numbers as Currency
Question details
The user needs to prevent spreadsheet software from automatically applying Accounting or Currency formatting to cells that are intended to be formatted as General.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Entering numerical data into spreadsheet columns and expecting it to remain as standard numbers.
- Observed behavior
- The software automatically changes the cell format from General to Accounting or Currency, displaying unwanted currency symbols next to the numbers.
Before changing the cell formats, ensure you have selected the exact range of data you want to modify to avoid accidentally removing intentional formatting from other parts of your spreadsheet.
Clear Existing Formats and Reapply General Formatting
Resetting the cell formatting completely ensures no hidden custom or accounting formats are applied automatically when you enter new data.
Sometimes simply changing the format dropdown back to 'General' isn't enough, as underlying formatting rules may still persist in the cell. Clearing all formats first provides a clean slate.
Click and drag to select the affected cell or range of cells in your worksheet.
Navigate to the 'Home' tab on the ribbon. Click on 'Clear' (usually represented by an eraser icon) in the Editing group, then select 'Clear Formats'.
Press the keyboard shortcut Ctrl+1 to open the Format Cells dialog box.
Select 'General' from the Number tab category list and click 'OK'.

Remove Conditional Formatting and Table Styles
Predefined table styles or conditional formatting rules can override your manual format settings and automatically apply currency formats.
Force Text Formatting for Specific Numbers
If the numbers are identifiers (like ID numbers, part numbers, or zip codes) and should never be calculated, forcing them as text prevents all automatic number formatting.
Fix Number Formatting Easily with WPS Spreadsheet
WPS Office offers a powerful, free spreadsheet tool that gives you complete control over your cell formatting without frustrating automatic overrides.
- 1. Open Your File: Launch WPS Spreadsheet and open your workbook.
- 2. Select Cells: Highlight the cells or columns displaying the unwanted currency format.
- 3. Clear Formatting: Go to the 'Home' tab, click the 'Clear' dropdown in the toolbar, and choose 'Clear Formats'.
- 4. Set to General: Right-click the highlighted cells, choose 'Format Cells', select 'General' under the Number tab, and click 'OK'.

Frequently Asked Questions
Why does Excel automatically change my numbers to dates or currency?
Spreadsheet programs use automatic format conversion to save time. If you enter a number that resembles a date, or if a cell previously held currency data (even if it was deleted), the software attempts to be helpful by reapplying that specific format automatically.
Can I disable automatic formatting globally in my spreadsheet?
You cannot completely turn off all automatic formatting globally. However, you can prevent it by pre-formatting empty columns as 'Text' before entering data, or by turning off 'Extend data range formats and formulas' in the software's Advanced Options menu.
Does pasting data from another source cause unwanted currency formatting?
Yes. Pasting data from a website, another document, or a different workbook often brings over the source's hidden formatting. To prevent this, right-click the destination cell and choose 'Paste Special' > 'Values' (or 'Match Destination Formatting').




