How to Stop Excel from Treating Plus and Minus Signs as Formulas
Question details
The user needs to enter data beginning with a plus (+) or minus (-) sign without Excel automatically evaluating the input as a mathematical formula.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Typing positive or negative values, specific coordinates, or text strings that naturally start with a '+' or '-' symbol.
- Observed behavior
- Excel automatically interprets any entry starting with a plus or minus sign as the beginning of a formula, which either calculates an unwanted result or throws a syntax error if the subsequent text is not a valid cell reference.
Check whether you need to use these signed entries in future mathematical calculations, as forcing them into text formats may cause functions like SUM or AVERAGE to ignore those cells.
Prefix the Entry with an Apostrophe
The quickest and most reliable way to prevent Excel from evaluating a plus or minus sign as a formula is to add a leading apostrophe.
Adding an apostrophe tells Excel to strictly treat the contents of the cell as text, bypassing any automatic formula detection. The apostrophe itself remains hidden from view in the spreadsheet.
Click on the cell where you want to enter your data.
Type a single quote character (') on your keyboard before typing anything else.
Type your plus or minus sign followed by your data (for example, '+123 or '-456) and press Enter.

Pre-format the Cells as Text
If you have a large range of cells where you need to enter signed numbers or text, formatting the entire range as Text beforehand is highly efficient.
Easily Handle Complex Data and Formulas with WPS Spreadsheet
WPS Spreadsheet provides powerful data formatting tools, allowing you to easily handle special characters, text entries, and complex formulas. You can bypass automatic formula conversion just as seamlessly as you would in Microsoft Excel.
- 1. Open your workbook: Launch WPS Spreadsheet and open the document you wish to edit.
- 2. Select your cells: Highlight the specific cells or columns where you need to input signed numbers.
- 3. Apply Text formatting: Right-click the selected area, choose 'Format Cells', navigate to the 'Number' tab, select 'Text', and click OK.
- 4. Enter your data flawlessly: Type your values starting with + or - directly. WPS Spreadsheet will preserve your signs without initiating any calculations.

Frequently Asked Questions
Is there a global Excel setting to disable plus and minus signs from starting a formula?
No, currently Microsoft Excel does not have a built-in global setting or toggle to disable the automatic recognition of + or - as mathematical operators. You must use formatting workarounds, such as adding an apostrophe or pre-formatting cells as Text.
Why does Excel automatically change a plus sign to a formula?
In spreadsheet applications like Excel, the plus sign (+) and minus sign (-) are standard mathematical operators. To speed up data entry for calculations, the software is programmed to assume any entry starting with these operators is meant to be evaluated as a formula.
Can I still calculate numbers if I format them as text with an apostrophe?
It depends on the calculation method. Simple arithmetic operations (like typing =A1+B1) can often still interpret text-formatted numbers and return a result. However, built-in functions like SUM will completely ignore cells that are formatted as text or prefixed with an apostrophe.




