If your Excel formulas are showing as text instead of calculating, the most common cause is the cell being formatted as Text before you typed the formula, and the fix is to change the cell format to General and re-enter the formula. A second frequent cause is a missing equals sign, and a third is the Show Formulas mode being accidentally turned on (Ctrl+`). Below are the exact steps for each cause, plus how to prevent the problem from happening again.
Why Excel Displays the Formula Instead of the Result
Excel treats anything you type into a cell as either a value, a formula, or text. A formula must start with an equals sign (=) and the cell must be formatted as General (or Number, Currency, etc.) for Excel to evaluate it. When the cell is formatted as Text, Excel interprets the entire entry—including the equals sign—as a literal string of characters. So you see =A1+B1 as text, not the sum.
Another subtle cause: if you type a leading apostrophe (') before the equals sign, Excel treats the whole entry as text and hides the apostrophe. This often happens when you paste a formula from a web page or another program that includes invisible characters.
Quick Fix: Change Cell Format and Re-enter
Here is the fastest way to fix a single cell or a small range:
- Select the cell(s) showing the formula as text.
- On the Home tab, in the Number group, open the dropdown and choose General (or Number).
- Press F2 to enter edit mode, then press Enter to confirm the formula again. (On a Mac, press Control+U then Return.)
- The formula should now calculate and display the result.
If you have many cells with this problem, select the entire column or range, set the format to General, then use Find & Replace to re-trigger the formulas: press Ctrl+H (Windows) or Cmd+H (Mac), find = and replace with =. This forces Excel to re-evaluate each cell as a formula.
Check if Show Formulas Mode Is On
Excel has a toggle that displays all formulas in the worksheet instead of their results. It is easy to turn on accidentally by pressing Ctrl+` (the grave accent key, usually below Esc). When this mode is active, every formula cell shows its formula text, and the column widths often widen.
To turn it off: press Ctrl+` again on Windows, or Cmd+` on a Mac. Alternatively, go to the Formulas tab and click Show Formulas (in the Formula Auditing group) to toggle it off. This mode is a display setting, not a formatting change, so your data is not corrupted.
Other Common Causes and Their Fixes
Beyond formatting and Show Formulas, a few other situations cause the same symptom:
- Missing equals sign: If you type
A1+B1without the leading=, Excel treats it as text. Simply add the equals sign at the beginning. - Leading apostrophe: If you see a small green triangle in the top-left corner of the cell, click the cell and then click the warning icon. Choose “Convert to Number” or remove the apostrophe manually by editing the cell.
- Cell formatted as Text via the Number Format dropdown: This is the same as the first cause, but sometimes the format is applied to a whole column before you type. Fix it as described above.
- Paste Special as Text: If you copied a formula from another program and used Paste Special > Text, it will come in as text. Re-paste using normal Ctrl+V (Cmd+V on Mac) or use Paste Special > Formulas.
- Circular reference warning: If a formula refers to its own cell, Excel may show a warning and display a 0 or the formula as text in some cases. Check the status bar for “Circular References” and fix the formula to refer to a different cell.
How to Prevent Formulas Turning into Text
Prevention is simpler than fixing. Follow these habits:
- Always start a formula with
=(or+or-which Excel converts to equals). - Before typing a formula in a new column, set the column format to General (Home > Number > General).
- Avoid pasting formulas from external sources directly; use Paste Special > Formulas (Ctrl+Alt+V, then F).
- Do not use the apostrophe key to “clear” a cell—use Delete or Clear Contents.
- If you import data from a CSV or text file, check the column formats after import; often they default to Text.
Excel for Mac and Excel for the Web Differences
The steps above work in Excel for Microsoft 365 on Windows. On a Mac, the ribbon paths are the same, but the keyboard shortcuts differ: use Cmd+` for Show Formulas, and Cmd+H for Find & Replace. In Excel for the web, the Show Formulas toggle is under the Formulas tab > Show Formulas, and the keyboard shortcut is Ctrl+` (Windows) or Cmd+` (Mac). The cell format fix is identical: select the cells, choose General from the Home tab, then re-enter the formula. Note that Excel for the web does not support the F2 key on all browsers; instead, double-click the cell or press Enter after selecting it to edit.
Frequently Asked Questions
Why does my formula show as text after I change the format to General?
Changing the format alone does not re-evaluate an existing text entry. You must re-enter the formula (press F2 then Enter) or use Find & Replace to force re-evaluation. The format change only affects new entries.
How do I fix an entire column of formulas showing as text?
Select the whole column, set the number format to General, then use Find & Replace (Ctrl+H) to replace = with =. Excel will re-parse each cell as a formula. Alternatively, use the Text to Columns wizard: select the column, go to Data > Text to Columns, choose Delimited, then Finish—this often converts text formulas to real formulas.
What does the green triangle in the corner of the cell mean?
That is an error checking indicator. Click the cell, then the warning icon that appears. If it says “The number in this cell is formatted as text,” choose “Convert to Number.” If it says “Formula uses a text-formatted cell,” you may need to fix the referenced cells.
Can I turn off Show Formulas mode permanently?
No, it is a toggle, not a setting. But you can avoid accidentally pressing Ctrl+` by being careful. If you frequently hit it, consider remapping the keyboard shortcut via Options > Customize Ribbon > Keyboard Shortcuts (Windows only).
Why does my formula show as text when I open a CSV file?
CSV files have no formatting information, so Excel often imports all cells as Text. After opening, select the column, change the format to General, and then use Text to Columns (Data > Text to Columns) to convert the formulas. Alternatively, use the Import Wizard (Data > From Text/CSV) and set the column data type to General during import.
Is there a way to see all formulas at once without changing the display?
Yes, you can use the Trace Precedents or Trace Dependents tools under the Formulas tab, or press Ctrl+` to toggle Show Formulas temporarily. For a printable list, you can use the FORMULATEXT function in a helper column: with a formula in A1, enter =FORMULATEXT(A1) in B1 to display the formula as text in another cell.
When to Use FORMULATEXT to See the Formula
If you want to keep the calculated result visible but also see the underlying formula in a separate cell, use the FORMULATEXT function. For example, with a formula in A1, type =FORMULATEXT(A1) in B1. This returns the formula as a text string. This is useful for auditing or teaching, and it does not affect the original cell’s calculation. Note that FORMULATEXT works in Excel 2013 and later, including Excel for the web.
Related
- SUBSTRING in Snowflake: Syntax, Examples, and Tips
- Excel Audit Process: Step-by-Step Guide
- Excel Audit Log Template: How to Build One
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- XLOOKUP Exact Match Not Working? Fix Common CausesXLOOKUP uses exact matching by default, so a failed result usually means the lookup value and the values…
- Excel Merged Cell Error: Causes, Fixes, and PreventionThe Excel message “We can’t do that to a merged cell” means the action you tried conflicts with…
- Excel Not Highlighting Columns? Fix Selection IssuesIf Excel is not highlighting a column, click its lettered heading at the top of the worksheet, or…
- SUMIFS Excel Error? Causes, Checks, and Practical FixesA SUMIFS error in Excel usually comes from a misspelled function or reference, criteria written in the wrong…
- Excel Sort Expand Selection Not Working? Try These FixesIf Excel’s Expand the selection option is not working, cancel the sort, select the entire data range—including every…
- Excel Page Break Not Removing? How to Fix ItIf an Excel page break will not go away, first check whether it is a manual break or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.