If Excel shows formulas as text, first check Show Formulas with Ctrl + ` or Formula tab > Show Formulas; if only one cell misbehaves, clear Text format and re-enter the formula. Leaving it alone gives wrong outputs, broken totals, and charts or reports that depend on those cells. This guide gives you the fastest checks and fixes for both causes.
What the symptom means
The symptom usually points to one of two paths: Excel is displaying every formula on the sheet, or one cell is being treated as text. Start with the quickest split. If the whole worksheet shows formulas, toggle Show Formulas. If only one cell shows the formula literal, inspect the cell format and the entry itself.
Say your budget sheet suddenly shows =SUM(B2:B12) in every total cell. That points to a worksheet-wide display setting. Suppose only one imported sales cell shows =C2+D2 while the rest calculate normally. That points to a single-cell text problem instead.
Most likely causes
Most often, the problem is either Show Formulas, Text formatting, or a formula entered as plain text. Less often, the issue comes from a missing equal sign, a leading apostrophe, quotes around the formula, or imported data that arrived as literal text from CSV or ERP output.
- Worksheet-wide display mode: Show Formulas is on for the sheet.
- Cell formatting: the cell is set to Text.
- Entry syntax: the formula is missing =.
- Text markers: a leading apostrophe, wrapped quotes, or a pasted text import forces text handling.
How do you turn off Show Formulas?
If every formula on the worksheet is showing, turn off Show Formulas first. This is a worksheet-wide display mode, so changing one cell will not help. Use the Formula tab or the keyboard shortcut, then confirm the sheet returns to calculated values. Microsoft documents the shortcut as a toggle for showing formulas in a worksheet, and it uses the same command as the ribbon button. Microsoft support: show formulas instead of results
- Open the Formula tab on the ribbon.
- In the Formula Auditing area, click Show Formulas to turn it off.
- Or press Control + ` to toggle the mode off.
- Check that the cells now show results instead of formula text.
If the whole sheet still shows formulas after that, the workbook may be opening in the same view again. Toggle the command once more. The shortcut and the ribbon button do the same thing.
Why is Excel treating my formula as text?
Excel treats a formula as text when the cell format is Text, when the entry starts without =, or when a leading space, apostrophe, or quote tells Excel not to calculate it. Microsoft notes that cells formatted as Text preserve what you type instead of evaluating it as a formula. Microsoft support: format numbers as text The shortest fix is to change the format to General, then re-enter the formula so Excel evaluates it again.
- Select the problem cell.
- Go to Home > Number Format and change Text to General.
- Click in the formula bar and confirm the entry starts with =.
- Press F2, then Enter, or delete and type the formula again.
A common mistake is entering a formula into a cell that is still formatted as Text, so Excel displays the formula instead of calculating it. Excel often keeps the old text entry until you re-enter it. That is why the cell can still display the formula literally after the format change.
How do I fix a formula that starts with an apostrophe?
A leading apostrophe tells Excel to store the entry as text on purpose. That helps keep a formula in progress, but it blocks calculation. Remove the apostrophe, make sure the formula begins with =, and then re-enter the cell so Excel recalculates it.
- Select the cell and look at the formula bar.
- Delete the leading ' before the equal sign.
- Confirm the formula now begins with =.
- Press Enter to calculate the cell.
If the apostrophe came from a paste, the formula may be embedded in imported text. In that case, typing the formula again in a clean cell is often faster than editing the imported string.
What if quotes or a missing equals sign are the issue?
If a formula is wrapped in single or double quotes, Excel treats it as text. The same happens when the entry is missing the initial =. Remove the quotes or add the equal sign at the front, then enter the formula again so Excel can evaluate it.
- Inspect the full entry in the formula bar.
- If it begins with quotes, remove them.
- If it does not begin with =, add it.
- Press Enter to recalculate.
If you only want to store text, paste as values or type the text directly. If you want a working formula, it must be entered as a formula, not as quoted text.
Formula triage decision tree
This one-page decision path separates the worksheet-wide case from the single-cell case. Use it before trying several fixes at random. The final checkpoint matters: after any format change, re-enter the formula or Excel may keep the old text behavior.
Download the one-page decision tree PDF
| Branch | What you see | Exact fix steps |
|---|---|---|
| Whole sheet vs one cell | Every formula on the worksheet displays | Go to Formula tab > turn off Show Formulas, or press Control + `. |
| Whole sheet vs one cell | Only one cell shows the formula text | Check the cell format, change Text to General, then continue to the re-entry step below. |
| Re-enter formula checkpoint | Format changed, but the cell still shows text | Press F2, then Enter, or delete and type the formula again so Excel recalculates it. |
Excel calculation mode can also keep formulas from updating
If formulas look correct but results stay stale, check calculation mode. In Excel Options > Formulas, Automatic updates formulas whenever inputs change, while Manual waits until you force a recalc. That setting does not usually make formulas display as text, but it can make a workbook seem broken because totals stay unchanged after edits.
- Open File > Options > Formulas.
- Under Calculation options, confirm Automatic is selected for normal workbooks.
- If the workbook is set to Manual, switch back to Automatic or recalculate with the workbook’s refresh command.
- Recheck the affected cells after the mode change.
Use Manual only when you intentionally want to control recalculation. If formulas are showing as text, this setting is usually not the root cause, but it is worth checking when values do not update after the formula issue is fixed.
Quick comparison of text-forcing markers and formats
These are the most common ways Excel is told to keep an entry as text instead of calculating it. If you are not sure which one is present, inspect the formula bar first, then check the cell format.
| Marker or format | What Excel does | How to fix it |
|---|---|---|
| Apostrophe at the start | Stores the entry as text and hides the apostrophe in the cell | Remove the apostrophe, keep the leading =, then re-enter the formula |
| Leading space | Can cause Excel to treat the entry as text instead of a formula | Delete the space and re-enter the formula |
| Single or double quotes around the formula | Treats the whole string as text, not a calculation | Remove the quotes and start the entry with = |
| Cell format set to Text | Preserves the entry exactly as typed and blocks calculation | Change the format to General, then press F2 and Enter |
| Text format plus pasted formula | Formula may stay literal until it is re-entered | Change to General and retype or re-enter the formula |
Still not working?
If the easy fixes fail, assume the formula arrived as literal text from another system. CSV exports, ERP downloads, and pasted reports can sometimes carry hidden apostrophes, spaces, or quote marks. In that case, retype the formula in a blank cell and compare the result.
- Copy the visible formula text into a blank cell.
- Manually type the formula again, starting with =.
- Check the source data for hidden apostrophes, leading spaces, or wrapped quotes.
- If the formula must be displayed on purpose, use FORMULATEXT instead of forcing text formatting.
Prevention is simple: keep formula cells in General format before entry, and avoid pasting formula text from external reports unless you plan to convert it. If a vendor file keeps arriving as text, clean it at import rather than fixing each cell by hand.
Frequently asked questions
Why is my Excel formula showing instead of the result?
The two most common reasons are Show Formulas being enabled or the cell being treated as text. Check the Formula tab first if the whole sheet changed, then inspect the cell format and the entry itself if only one cell is affected. A missing equal sign, apostrophe, or quotes can also block calculation.
How do I turn off show formulas in excel?
Go to Formula > Show Formulas and click it off, or press Control + ` to toggle it. That command affects the entire worksheet, so it is the right fix when every formula is showing instead of results. Microsoft’s support documentation describes this as the Show Formulas toggle for switching formulas and results in the worksheet. Microsoft support: show formulas instead of results
Why does changing cell format to General not update the formula?
Changing the format only changes how Excel will treat new input. Existing text often stays text until you re-enter the formula. Select the cell, press F2, then Enter, or type the formula again after changing the format.
How do I make Excel recalculate a formula after changing text formatting?
After switching the cell from Text to General, use F2 followed by Enter. That forces Excel to parse the entry again. If the formula was pasted with an apostrophe or wrapped in quotes, remove those markers before re-entering it.
What does it mean if a formula is wrapped in quotes in Excel?
Quotes tell Excel to treat the entry as text, so the formula will not calculate. Remove the single or double quotes, then make sure the entry starts with =. If you want the formula text visible on purpose, use FORMULATEXT instead.
How can I tell whether the problem is one cell or the whole worksheet
If every formula on the sheet shows as text, the issue is worksheet-wide Show Formulas. If just one cell misbehaves, the issue is usually cell format, a missing equal sign, or a text marker such as an apostrophe. That split tells you which fix to try first.