How to Enter Text Starting with Equals, Minus, or At Signs in Excel
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.

- 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.
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.
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.
Click on the cell where you want to type the data.
Press the apostrophe key (') on your keyboard.
Type your text immediately after the apostrophe, for example: '@username or '-500.
Hit the Enter key. The apostrophe will disappear from the cell display, and only your intended text will be visible.

Format the Cell as Text Before Typing
Best for entering data into multiple cells or entire columns without needing to type an apostrophe every single time.
Display an Existing Formula as Text
Use this function when you want a cell to visibly show the formula used in another cell rather than manually retyping it.
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. Open WPS Spreadsheet: Launch WPS Office and open your workbook.
- 2. Select target cells: Highlight the cells where you want to type your special characters.
- 3. Change format to Text: Right-click the selection, choose 'Format Cells', navigate to the 'Number' tab, select 'Text', and click OK.
- 4. Enter your data: Type your data starting with =, -, or @ safely without triggering formulas.

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.




