Formula Errors

How to Stop Excel from Treating Plus and Minus Signs as Formulas

Kushani NimanthikaKushani Nimanthika Nov 2, 2026 876 views

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.

How to Stop Excel from Treating Plus and Minus Signs as Formulas
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the target cell

Click on the cell where you want to enter your data.

2
Type an apostrophe

Type a single quote character (') on your keyboard before typing anything else.

3
Enter your signed value

Type your plus or minus sign followed by your data (for example, '+123 or '-456) and press Enter.

Prefix the Entry with an Apostrophe
Invisible Formatting: Excel stores the value as text and displays the plus or minus sign perfectly, while keeping the apostrophe completely hidden in the worksheet view.
Advanced Data Management

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. 1. Open your workbook: Launch WPS Spreadsheet and open the document you wish to edit.
  2. 2. Select your cells: Highlight the specific cells or columns where you need to input signed numbers.
  3. 3. Apply Text formatting: Right-click the selected area, choose 'Format Cells', navigate to the 'Number' tab, select 'Text', and click OK.
  4. 4. Enter your data flawlessly: Type your values starting with + or - directly. WPS Spreadsheet will preserve your signs without initiating any calculations.
Prevent unwanted formula conversions effortlessly using the apostrophe trick.Fully compatible with Microsoft Excel (.xlsx and .xls) file formats.Format large datasets as text in bulk with a lightweight, intuitive interface.
QA img-9

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.