Formatting Issues

How to Enter Text Starting with Equals, Minus, or At Signs in Excel

Steve KSteve K Oct 28, 2026 876 views

Question details

The user needs a way to input specific characters like equals (=), minus (-), or at signs (@) at the beginning of a cell without Excel automatically treating the entry as a formula.

How to Enter Text Starting with Equals, Minus, or At Signs in Excel
Product
Excel
Device & OS
not provided
Scenario
Typing standard data that begins with mathematical operators or symbols, such as social media handles (@username), negative item descriptions (-item), or text demonstrating a formula.
Observed behavior
Excel automatically attempts to calculate the entry, resulting in unintended numerical calculations, #NAME? errors, or formula validation popups instead of displaying the plain text.
Before you start

Determine if you simply want to type plain text that starts with a special character, or if you are trying to display a functioning formula from a different cell as readable text.

Solution 1Recommended

Use a Leading Apostrophe

The fastest and most common method to force Excel to treat a single entry as plain text.

By typing a single quotation mark (apostrophe) before your text, you tell Excel to bypass any automatic formula evaluations. The apostrophe will remain hidden in the spreadsheet view, but your text will display exactly as typed.

1
Select the target cell

Click on the cell where you want to type the data.

2
Type an apostrophe

Press the apostrophe key (') on your keyboard.

3
Enter your data

Type your text immediately after the apostrophe, for example: '@username or '-500.

4
Press Enter

Hit the Enter key. The apostrophe will disappear from the cell display, and only your intended text will be visible.

Use a Leading Apostrophe
Visible Apostrophe Check: If the apostrophe remains visible in the cell, check to make sure you didn't accidentally type two apostrophes, or verify that the cell isn't already formatted with a custom text rule that forces all characters to show.
Free Microsoft Office alternative

Handle Text and Formulas Effortlessly in WPS Spreadsheet

WPS Spreadsheet operates just like Microsoft Excel, allowing you to easily enter special characters, utilize the apostrophe shortcut, and format cells as text without calculation errors.

  1. 1. Open WPS Spreadsheet: Launch WPS Office and open your workbook.
  2. 2. Select target cells: Highlight the cells where you want to type your special characters.
  3. 3. Change format to Text: Right-click the selection, choose 'Format Cells', navigate to the 'Number' tab, select 'Text', and click OK.
  4. 4. Enter your data: Type your data starting with =, -, or @ safely without triggering formulas.
100% format compatibility with Microsoft Excel (.xlsx, .xls) files.Identical cell formatting and formula text functions.Free and lightweight solution for daily data entry.Familiar user interface requiring zero learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show a #NAME? error when I start a cell with @?

Excel treats the @ symbol as an operator for functions or implicit intersection in newer versions. If the text following the @ is not recognized as a valid function or defined name, Excel doesn't know how to calculate it and returns a #NAME? error.

Can I remove leading apostrophes from multiple cells at once?

Yes. Select the cells containing the apostrophes, go to the Data tab, and click 'Text to Columns'. Without changing any settings in the wizard, simply click 'Finish'. This refreshes the cell formatting and converts them back to standard text.

Why does my formula not work after I delete the leading apostrophe?

If you delete the apostrophe but the formula still displays as text, the cell is likely still formatted as 'Text'. Select the cell, change the number format from 'Text' to 'General' on the Home tab, then double-click inside the cell and press Enter to recalculate it.

Does the apostrophe trick affect CSV exports?

Yes. When saving a spreadsheet as a CSV file, the leading apostrophe may be saved as literal text data rather than a hidden formatting cue. To avoid this in CSVs, it is better to pre-format the column as Text instead of typing apostrophes.