If Excel is showing a formula instead of its result, first check whether Show Formulas is turned on; if it is not, the cell may be formatted as Text or the entry may contain a leading apostrophe or space. Turn off formula display with Formulas > Show Formulas, or change a text-formatted cell to General and re-enter the formula.
Why Excel displays a formula instead of a result
Normally, a cell displays the calculated result while the formula bar shows the formula used to produce it. For example, a formula can be visible in the cell itself if Excel is in Show Formulas view. The same appearance can occur when Excel has stored the entry as text instead of interpreting it as a formula. These causes look similar, but the right fix depends on whether the issue affects one cell or many.
Start by comparing the affected cell with nearby cells. If formulas are visible throughout the worksheet, Show Formulas is a strong possibility. If only one cell—or a few cells—shows an expression beginning with an equals sign, check its number format and how the formula was entered. Also inspect the formula bar: it can reveal a leading apostrophe or other characters that are not obvious in the grid.
Turn off Show Formulas
In Excel for Microsoft 365 on Windows, go to Formulas > Show Formulas. If the command is selected, click it to return to normal result view. The setting applies to the active worksheet, so another sheet in the same workbook may have a different display setting. A keyboard shortcut is Ctrl+` (the grave-accent key, often beside 1 on a US keyboard). Press it again to switch views back.
Show Formulas is useful when auditing a worksheet because it reveals calculations instead of their outputs. Excel may widen columns to make the expressions easier to read, so the sheet can look different even after the setting is changed. This view does not replace formulas with text or change their calculations; it changes how the worksheet displays them.
- If all or most formulas suddenly appear across one sheet, check Show Formulas first.
- If just one cell displays an expression, check its format and entry characters.
- If a cell shows an old number rather than the formula, investigate calculation settings instead.
Check whether the cell is formatted as Text
A cell formatted as Text tells Excel to preserve what you type as text. If you enter a formula into such a cell, Excel may display the characters rather than calculate them. This often happens after a column was prepared for imported data, or when a cell was formatted as Text before someone typed a formula.
To check, select the cell and look at the Number Format box on the Home tab. If it says Text, change it to General. Changing the format alone usually does not convert an existing text entry into a working formula: Excel needs the entry to be submitted again. After changing the format, press F2 and then Enter to re-enter that cell’s contents. On Windows, you can also open Format Cells with Ctrl+1, choose General on the Number tab, and confirm.
For a group of affected cells, select the range, set the format to General, and re-enter the contents. If the cells contain only formulas and the range is consistent, Data > Text to Columns followed by Finish can sometimes make Excel reinterpret text entries. Use this cautiously: Text to Columns is a data-conversion tool, and its delimiter or data-type choices can affect other contents. Make a copy first if the range includes mixed data, dates, or identifiers.
Look for a leading apostrophe, space, or missing equals sign
Excel recognizes a formula when it is entered as a formula, normally beginning with an equals sign. A leading apostrophe forces an entry to be treated as text; the apostrophe itself may not appear in the cell grid, but it can be seen in the formula bar. A space before the equals sign can also prevent Excel from recognizing the entry as a formula. Remove the unwanted character, then press Enter.
Also verify that the expression actually starts with an equals sign. For example, typing a function name without the equals sign does not ask Excel to calculate it. Conversely, an equals sign inside a longer text entry does not necessarily turn that whole entry into a formula. Imported files and copied data can bring along invisible spaces or apostrophes, so compare the exact cell contents rather than relying only on how the entry looks.
For example, with the value 12 in A2 and 8 in B2, enter this in C2 to add them: =A2+B2. The result should be 20. If C2 shows the expression literally, check Show Formulas, the cell format, and any leading characters.
Make Excel recalculate when the result is stale
A different problem occurs when a cell displays a number but that number does not update after its inputs change. This is not the same as seeing the formula itself. The workbook may be set to manual calculation, which delays recalculation until you request it. On Windows, check Formulas > Calculation Options and select Automatic if that is appropriate for the workbook.
Calculation mode can affect the workbook’s results, especially in large models where manual calculation is used deliberately to avoid repeated recalculation. With a simple example, if A2 contains 12 and B2 contains 8, a formula in C2 should add those two cells:
With 12 in A2 and 8 in B2, enter this formula in C2; it returns 20: =A2+B2.
If the cell instead shows =A2+B2 as text, calculation mode is not the cause; check the display and formatting issues above. If it shows a number that does not change after A2 or B2 changes, calculation mode or a formula reference may be relevant. Pressing F9 recalculates open workbooks in many Windows Excel contexts, but it does not fix a cell stored as text.
Use a small test to identify the cause
A controlled test can separate a worksheet-wide display setting from a cell-specific problem. In an unused cell formatted as General, enter a simple calculation. With no other cell references needed, type =2+3; a normally calculated cell displays 5. If it displays the expression, check Show Formulas first, then confirm the test cell is General and that there is no leading apostrophe or space.
Next, select a cell that is showing a formula and inspect the formula bar and Number Format box. If the format is Text, change it to General and re-enter the contents. If the format is already General and the formula bar shows an apostrophe or a space before the equals sign, remove that character. If the sheet-wide toggle was on, switching it off should reveal results without re-entering formulas.
When checking a function, use a small range with known values. With 10, 15, and 20 in B1:B3, place this formula in another General-formatted cell; it returns 45: =SUM(B1:B3). If Excel displays the formula text, diagnose the cell as described above. If it returns an unexpected number, check that the referenced cells contain numbers and that the range is correct.
Windows, Mac, and Excel for the web
The instructions above use Excel for Microsoft 365 on Windows. In Excel for Mac, the Show Formulas command is on the Formulas tab, although ribbon layout and keyboard shortcuts can vary by version and keyboard. If the Windows shortcut does not work on a Mac, use the ribbon command rather than guessing a key combination. Format Cells and the General number format are also available on Mac, though the dialog layout may differ.
Excel for the web has a Formulas tab with a Show Formulas command in supported layouts, but the ribbon can look different from the desktop application. If you cannot find the command, use the web version’s ribbon search or open the workbook in the desktop app. Keyboard shortcuts may also vary by browser, operating system, and keyboard layout. The cell-format principle is the same: a text-formatted entry must be made into a formula again after its format is corrected.
Prevent formula-display problems
When preparing a worksheet for calculations, keep formula cells in General or another appropriate numeric format rather than Text. Be deliberate when importing data: a column that needs to preserve leading zeros, such as product codes, may correctly need Text, while a calculation column usually should not. Avoid applying Text to an entire sheet unless that is intentional.
- When pasting formulas, check one or two cells to confirm they calculate before filling the whole range.
- Use Show Formulas intentionally for auditing, and switch back to normal view when finished.
- For imported or copied content, inspect for leading apostrophes and spaces if formulas remain visible.
- Keep a backup before bulk conversions, especially if the selected range mixes formulas, dates, and text identifiers.
Remember that a formula visible in the grid is not automatically evidence that the formula is incorrect. It may be a display choice, a text-format issue, or a character-entry issue. A displayed result that is outdated is a separate calculation problem, and a displayed error such as #VALUE! means Excel did calculate but encountered an issue in the expression or its inputs.
Frequently Asked Questions
Why are all my formulas showing in Excel?
The most likely reason is that Show Formulas is enabled for the worksheet. Go to Formulas > Show Formulas to turn it off, or use Ctrl+` on Windows. If only some cells are affected, also check whether those cells are formatted as Text.
Why does Excel show the formula in one cell but calculate the others?
That cell may have a Text format, a leading apostrophe, or a space before the equals sign. Set its format to General, remove unwanted characters, and press F2 followed by Enter so Excel interprets the entry again.
Will changing Text to General make a formula calculate automatically?
Not necessarily. Changing the number format does not always reinterpret content already stored as text. After selecting General, re-enter the cell with F2 and Enter, or use a suitable conversion method on a carefully checked range.
Why does my formula show an old answer instead of the formula?
That is usually a recalculation issue rather than formula display. Check Formulas > Calculation Options and consider setting calculation to Automatic. Also make sure the formula references the cells you intended.
Does Show Formulas change or delete my formulas?
No. It changes the worksheet’s display so formulas are visible instead of their results. Turning it off restores the normal result view; it does not undo or replace the formulas.
Related
- Excel Data Validation Source: Lists, Ranges, and Rules
- Excel Data Validation Rules: How They Work and When to Use Them
- Excel Data Validation Restrictions and Their Limits
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Find Month and Year From a Date in Excel with FormulasTo find a month and year from a date in Excel, enter =MONTH(A2) for the month number and…
- Conditional Formatting Custom Formula: Excel RulesIn Excel for Microsoft 365 on Windows, a conditional formatting custom formula is a TRUE-or-FALSE formula that decides…
- How to Share a Calendar in Outlook with the Right AccessTo share a calendar in Outlook, open Calendar, choose the calendar you own, select Share or Share Calendar,…
- Aggregate Functions in UPDATE: What SQL AllowsUsually, no: SQL does not allow an aggregate such as AVG() or SUM() directly as a row-level value…
- Excel Sum Positive Values Only: Formulas and ExamplesTo sum only positive values in Excel, use SUMIF with the criterion ">0". If the numbers are in…
- Average Between Two Dates in Excel: Formulas & TipsTo average values whose dates fall between two dates in Excel, use =AVERAGEIFS(B2:B100,A2:A100,">="&E2,A2:A100,"<="&F2). This averages numbers in B2:B100…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.