If Excel is showing a formula instead of its result, first turn off Show Formulas from the Formulas tab; on Windows, Ctrl+` toggles it. If only one cell is affected, change its format from Text to General, then re-enter the formula with F2 and Enter. These fixes address the two most common causes: formula-view mode and a formula Excel has stored as plain text.
Start with the quickest fix
Look at the worksheet before editing the formula. If many formula cells across the sheet are displaying expressions rather than answers, Show Formulas is probably on. Go to Formulas > Formula Auditing > Show Formulas and switch it off. In Microsoft 365 for Windows, the keyboard shortcut is Ctrl+`; the grave-accent key is often beside the number 1. The ribbon command is a good alternative if your keyboard layout makes that shortcut awkward.
When only one cell—or a few scattered cells—shows formula text, check how those cells are formatted and how the formula was entered. Select a problem cell and look at the formula bar. If the formula bar shows the expected expression but the cell itself shows the expression too, the cell may be formatted as Text or the entry may begin with an apostrophe. A single-cell problem is less likely to be caused by Show Formulas, which normally affects the worksheet broadly.
- Many formulas visible: turn off Show Formulas.
- One or a few formulas visible: check Text formatting, apostrophes, and spaces before the equals sign.
- A number appears but is not current: investigate calculation settings instead; that is a different issue.
What Show Formulas does
Excel normally evaluates a formula and displays its result in the cell. Show Formulas changes the worksheet display so that formula cells show their underlying expressions instead. It does not replace, delete, or convert the formulas, and it does not change their calculated results. Turning the command off returns the usual result display.
This mode is useful when auditing a worksheet: it lets you scan formula patterns, spot a reference that differs from its neighbors, or check whether a cell contains a formula at all. It can also make the sheet look broken if it was enabled accidentally. Because the displayed expressions take more space than many results, Excel may widen columns or make the sheet appear crowded while the mode is active. That change in appearance is not evidence that the formulas themselves have been altered.
The command applies to the active worksheet, so formulas on one sheet can appear normally while formulas on another sheet are shown as text. If the whole workbook seems affected, check each relevant sheet rather than assuming that every sheet has the same display setting. The formula bar is separate: selecting a formula cell normally shows its formula in the formula bar even when the worksheet displays its calculated result.
Fix a cell formatted as Text
A cell formatted as Text tells Excel to treat new entries as literal characters. If you type a formula into such a cell, Excel may keep the characters on display rather than evaluating them. Changing the cell to General is often necessary, but changing the format alone does not reliably make an already-entered text string calculate. Re-enter the formula after changing the format.
- Select the affected cell or range.
- On the Home tab, open the Number Format list in the Number group and choose General.
- Activate each affected cell with F2, then press Enter. For a range, use this on each cell that needs to be reinterpreted, or retype the formulas.
For example, with the values 3, 5, and 7 in B2:B4, a formula entered in B5 should calculate to 15. With those values in place and B5 intended to hold the total, enter =SUM(B2:B4). If B5 was Text-formatted when the formula was entered, set it to General and re-enter the expression. The cell should then show 15, while the formula bar shows the formula when B5 is selected.
Be cautious when changing formats in a range that also contains identifiers such as product codes, postal codes, or account numbers. Those entries may intentionally be stored as text to preserve leading zeros or prevent unwanted conversion. Correct only the cells meant to contain formulas.
Check for an apostrophe or a leading space
An apostrophe typed before an entry tells Excel to treat that entry as text. It may not be obvious in the cell, but it can make an apparent formula remain unevaluated. A space before the equals sign can have a similar effect because the entry no longer begins with the formula marker. Inspect the formula bar or edit the cell to see whether there is an extra character before the intended formula.
If the cell contains an accidental apostrophe or leading space, remove that character, confirm the cell is formatted as General, and press Enter to commit the corrected entry. Do not remove an apostrophe from a cell where it is intentional, such as a text value that must preserve leading zeros. Also check that the formula starts with an equals sign. Text that merely resembles a calculation will not be evaluated as a formula.
When a formula has been pasted from a web page, email, or another program, it may include invisible spaces or typographic characters. Retyping the formula directly in Excel can be a useful diagnostic. If the retyped version calculates, compare the original carefully rather than assuming that the visible characters were identical.
Distinguish formula text from a calculation problem
Manual calculation is sometimes blamed when a formula appears not to work, but it usually causes a different symptom. If calculation is set to Manual, a cell generally continues to display a previously calculated result until Excel recalculates; it does not normally switch to displaying the formula text. To check the setting in Microsoft 365 for Windows, open Formulas > Calculation Options and select Automatic if automatic recalculation is appropriate for the workbook.
If the cell displays a number that seems outdated, press F9 to recalculate formulas in open workbooks. On a Mac, calculation shortcuts differ, so use the calculation commands on the Formulas tab rather than relying on the Windows shortcut. Large workbooks sometimes use Manual calculation deliberately to avoid repeated, slow recalculation; check with the workbook owner before changing that setting.
Other symptoms also point away from formula text. A cell showing #NAME? or #VALUE! is displaying an error result, which calls for checking the formula spelling, references, or input values. A cell displaying #### often needs a wider column or a different number format. Neither symptom is the same as seeing the formula characters themselves.
Check formula entry and separators
After confirming the display mode and cell format, verify that the expression is valid for the workbook. A formula must begin with an equals sign, refer to the intended cells, and use function names and separators Excel recognizes. In some regional settings, Excel uses semicolons rather than commas between function arguments. If you copied a formula written for a different regional setup, Excel may reject it or interpret it differently. That is distinct from Show Formulas, but it is worth checking when a formula fails after being re-entered.
For a straightforward multiplication example, suppose A2 contains 12 and B2 contains 4. With those values in place and C2 selected as the result cell, enter =A2*B2; the expected result is 48. If Excel shows the expression rather than 48, return to the display-mode and Text-format checks. If it shows an error, examine the cell references and the actual contents of A2 and B2.
Do not add quotation marks around a formula unless the formula specifically requires text as an argument. For instance, entering an expression as a quoted text string is not the same as entering it as a calculation. If a formula is copied from another cell, also confirm that relative references have not shifted unexpectedly; the formula bar lets you inspect the exact references in the selected cell.
Prevent the problem when entering or importing data
Set formula cells to General before entering formulas, especially in a template that previously used Text formatting. If you paste formulas into a prepared workbook, check a few results immediately rather than assuming that every pasted expression was interpreted correctly. For a large imported range, test a representative cell first, then apply the fix consistently only after confirming the cause.
- Use Show Formulas intentionally for auditing, and turn it off when you finish reviewing the sheet.
- Keep formula cells separate from text-entry columns when designing a template.
- When pasting, use a small test range if you are unsure whether the destination formatting will affect the entries.
- Before changing number formats in bulk, check whether the range contains text values that need to retain their exact appearance.
Formatting is not just decoration in Excel: it can influence how an entry is interpreted, especially when a cell is set to Text before data is entered. Conversely, formulas are still stored as formulas when a cell merely displays a calculated value. Selecting the cell and checking the formula bar is a quick way to distinguish the stored expression from its on-sheet display.
Frequently Asked Questions
Why is Excel showing formulas in every cell?
Show Formulas is likely enabled for that worksheet. Turn it off with Formulas > Formula Auditing > Show Formulas. On Windows, Ctrl+` also toggles the setting.
Why does only one Excel cell show the formula?
The cell may be formatted as Text, or its entry may begin with an apostrophe or space. Set the cell to General, remove any unintended leading character, then re-enter the formula.
Will changing Text to General fix a formula already in the cell?
Not always by itself. After changing the number format to General, activate the cell with F2 and press Enter so Excel reinterprets the entry. Retyping it is another option.
Why does Excel show an old answer instead of updating?
That usually suggests a calculation issue, not formula display. Check Formulas > Calculation Options for Manual calculation, then recalculate as appropriate. Confirm the workbook’s intended settings before changing them.
Does Show Formulas change or remove my formulas?
No. It changes how formulas are displayed on the worksheet, not the formulas or their results. Switch the command off to return to the normal result display.
Related
- Excel Quick Border: Add Cell Borders Fast in Microsoft 365
- Excel Print Zoom to Fit Page: Setup and Common Fixes
- Excel Print: Keep Row and Column Headers on Every Page
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Import CSV with Decimal Point: Fix Number ParsingTo import a CSV with decimal points correctly in Excel for Microsoft 365 on Windows, use Data >…
- Excel Shortcut Keys Not Working? Fix the Common CausesIf Excel shortcut keys are not working, first check whether you are editing a cell, using Excel for…
- COUNTIFS Not Working With Dates? Fix the CriteriaYes—COUNTIFS often misses dates because its criteria are written as text, the cells contain text rather than real…
- XLOOKUP Not Working? Check These Format IssuesYes—differences in the underlying data type or characters can make XLOOKUP return no match, even when two cells…
- SUMIFS Not Working With Multiple Criteria? Common FixesWhen SUMIFS is not working with multiple criteria, first check that its arguments are in the right order…
- Excel Freeze Panes Not Freezing Selection? Fix ItExcel Freeze Panes does not lock the cell or range you select; it keeps the rows above and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.