Formula guide · Excel and Google Sheets · Updated May 13, 2026
Excel Formula Shows as Text
Fix formulas that display as plain text instead of calculating in Excel or Google Sheets.
Quick Answer
If a formula shows as text, change the cell format from Text to General, remove any leading apostrophe, and re-enter the formula.
Copyable Formula
=A2+B2Syntax
Check cell format, leading apostrophes, Show Formulas mode, and separators.Excel and Google Sheets
Worked Example
| Cause | Fix |
|---|---|
| Cell formatted as Text | Change to General and re-enter |
| Leading apostrophe | Remove the apostrophe |
| Show Formulas enabled | Turn it off |
Result: After the cell is treated as a formula cell again, the spreadsheet calculates the result.
Steps
- Select the cell and check whether its number format is Text.
- Change the format to General or Automatic.
- Remove any apostrophe before the equals sign.
- Edit the cell and press Enter so the formula recalculates.
Common Mistakes
- Changing the format but not re-entering the formula.
- Missing a leading apostrophe because it is easy to overlook.
- Confusing Show Formulas mode with a broken formula.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.