If Excel is showing a formula instead of its result, first turn off Formulas > Show Formulas; on Windows, you can also press Ctrl+` (the grave-accent key). If only particular cells are affected, check whether those cells are formatted as Text or whether the formula begins with an apostrophe or space.
First determine which problem you have
Excel can display a formula rather than a calculated value for two different reasons. It may be deliberately displaying formulas across the worksheet, or the affected cell may contain text that looks like a formula but is not being evaluated. A third possibility is that Excel recognizes the formula but has not recalculated it yet.
Look at how widespread the issue is. If many formula cells on the sheet show expressions such as =SUM(B2:B10), while ordinary values remain visible, check Show Formulas first. If just one cell displays its formula and nearby formula cells show numbers, inspect that cell’s format and contents. If the cell displays a number that seems out of date, check calculation mode instead.
You can also click a problem cell and inspect the formula bar. If the cell itself visibly shows the formula, the formula bar can help confirm whether the content starts with an equals sign, an apostrophe, or an unexpected space. These clues narrow the fix without changing the rest of the workbook.
Turn off Show Formulas
Show Formulas is a worksheet display option. When it is on, Excel displays formulas in cells instead of their results. It does not convert formulas to text, remove formulas, or stop calculation. That is why the setting can make an entire sheet look broken even though its formulas are still present.
- Open the affected worksheet and select the Formulas tab.
- In the Formula Auditing group, select Show Formulas to switch the display back to calculated results.
- Alternatively, on Windows, press Ctrl+`. The grave-accent key is usually near the upper-left corner of the keyboard, though its position can vary by layout.
When Show Formulas is enabled, Excel may widen columns so that longer expressions fit. After turning it off, the columns may remain wide; that does not mean the setting failed. Adjust their widths if you want the sheet to return to its previous appearance. The toggle applies to the active worksheet, so check other sheets separately if they also display formulas.
On a Mac, use Formulas > Show Formulas if the keyboard shortcut differs on your keyboard or does not work. The Control+grave-accent shortcut is available in many Excel for Mac configurations, but keyboard layouts and system shortcuts can affect it. In Excel for the web, use the Show Formulas command on the Formulas tab when available rather than assuming a Windows shortcut will behave the same way.
Check calculation mode if results are stale
If Excel shows a numeric result but that result does not change after you edit an input, the workbook may be using manual calculation. In Excel for Microsoft 365 on Windows, select Formulas > Calculation Options > Automatic. In automatic mode, Excel recalculates formulas when relevant cells change. The setting can affect more than one open workbook, so check it when formulas in several files seem not to update.
To prompt a recalculation without changing the mode, press F9 to calculate formulas in open workbooks. Shift+F9 recalculates the active worksheet. On many Mac keyboards, use Fn+F9 or the equivalent function-key combination configured for your device; you can also use the Calculation Options menu. Recalculation is useful for stale values, but it will not fix a cell that contains text instead of a formula.
Calculation mode is especially worth checking in large workbooks, where someone may have selected Manual to avoid waiting after every edit. If you switch to Automatic and the displayed result changes, the formula was likely valid but had not been recalculated. If it still displays the expression itself, investigate Show Formulas or the cell’s text format.
Fix a formula stored as text
A cell formatted as Text tells Excel to treat what you type as characters. That can prevent an expression from being evaluated. The same can happen if an apostrophe or a leading space appears before the equals sign. For example, a cell containing an apostrophe followed by =A1+B1 is text, even though it resembles a formula. The apostrophe may not be obvious in the cell, so inspect the formula bar.
For a single affected cell, try this repair:
- Select the cell and choose Home > Number Format, then select General.
- Press F2 to edit the cell, then press Enter to make Excel re-read the contents.
- Confirm that the formula now displays a result. If not, remove any leading apostrophe or spaces before the equals sign and press Enter again.
Changing the format to General does not necessarily make an existing text entry calculate immediately. That is why re-entering the cell is important. For a large range, test the process on a copy or a few cells first; bulk conversion methods can affect other text in the selection. On Mac, the same basic approach applies, though the key used to edit a cell may depend on your keyboard settings.
A useful example: with units in A2 and unit price in B2, enter the formula below in C2. If A2 contains 4 and B2 contains 9, the result should be 36.
=A2*B2
If C2 shows the literal characters =A2*B2, make sure C2 is General, remove any prefix before the equals sign, and re-enter the formula. If it shows 36 but the value seems wrong, the issue is probably the inputs or calculation logic rather than formula display.
Look for spaces, apostrophes, and missing equals signs
Excel formulas normally begin with an equals sign. Typing SUM(A1:A5) without the equals sign enters ordinary text; Excel does not infer that you meant a formula. A leading space can also interfere, particularly if it appears before the equals sign. Remove the extra character, enter the equals sign first, and then confirm the formula with Enter.
Some worksheets intentionally store formula examples as text, such as training materials that show what to type. In those cells, the text format or an apostrophe may be deliberate. Before converting a range, check whether the workbook is meant to display formulas as examples. This distinction matters because changing text to formulas can alter the intended content.
Check formula entry and syntax
If the cell does not show a formula result and Excel displays an error or a dialog, the issue may be invalid syntax rather than a display setting. Check that parentheses are balanced, cell references are valid, and text values are enclosed in straight double quotation marks. Also confirm the argument separator expected by your regional settings; many installations use commas, while some use semicolons.
For example, a function name or range reference typed incorrectly can produce an error instead of the expected answer. An error such as #NAME? often indicates that Excel does not recognize part of the expression, while #VALUE! can indicate an incompatible value. Those errors are different from seeing the complete formula as literal text. Fixing syntax will not help if Show Formulas is simply turned on.
When troubleshooting a complicated formula, test a simpler expression in a blank cell and verify that it calculates. Then build the original expression back up in smaller parts. This helps distinguish a general calculation setting from a problem in one formula’s references or arguments.
Check references and dependencies
A formula can calculate correctly and still appear not to work if it refers to the wrong cells. Click the formula cell and review the colored reference outlines, or select Formulas > Trace Precedents to see which cells feed into it. A reference to a blank cell, an unexpected row, or an overwritten input can explain an incorrect result without any display problem.
Excel may also warn about a circular reference, where a formula directly or indirectly depends on its own result. For instance, a total formula placed inside the range it totals can create a circular reference. Excel’s handling depends on workbook settings, and iterative calculation may be used deliberately in some models. For an ordinary worksheet, correct the reference so that the formula does not include itself. A circular-reference warning is not the same as Show Formulas, but it can make results confusing.
External workbook links and data connections are another separate issue. A formula that refers to another file may show a cached value or prompt about updating links, depending on the file and its settings. Refreshing a connection or updating a link is different from recalculating a normal formula. If the cell displays the expression itself, first rule out display mode and text formatting before investigating external data.
What to do when the quick fixes do not work
Use a small, controlled check rather than repeatedly changing settings across the workbook:
- In a blank cell, type a simple expression such as =1+1. If it returns 2, Excel can calculate in that workbook.
- If the new expression also appears literally, switch off Show Formulas and check the blank cell’s number format.
- If the test calculates but one existing cell does not, inspect that cell for text formatting, an apostrophe, spaces, or a formula-specific error.
- If formulas return old values after inputs change, select Automatic calculation and recalculate.
- If only one workbook behaves differently, compare its calculation setting, links, and worksheet-specific display state with a workbook that works.
Save a copy before making broad changes, especially if you are converting many cells from text or repairing a shared template. That gives you a way to restore the original content if the range includes notes, identifiers, or formula examples that were meant to remain text.
Frequently Asked Questions
Why is Excel showing formulas in every cell?
The Show Formulas option is probably enabled for that worksheet. Select Formulas > Show Formulas to turn it off, or press Ctrl+` on Windows. If the issue affects only one cell, check that cell’s format and contents instead.
Why is Excel showing the formula instead of the answer in one cell?
That cell may be formatted as Text, or its contents may begin with an apostrophe or space. Change its format to General, edit the entry, and press Enter. Also verify that the equals sign is the first character in the formula.
Why does my Excel formula not update when I change a value?
Check Formulas > Calculation Options and choose Automatic. If calculation is already automatic, press F9 to recalculate and inspect the formula’s references to confirm it points to the cells you changed.
Does changing Text to General fix a formula automatically?
Not always. Changing the number format may leave the existing entry stored as text. After selecting General, edit the cell and press Enter so Excel reinterprets the contents as a formula.
Why does Excel show an error instead of calculating my formula?
An error usually points to a formula, reference, or input problem rather than the Show Formulas setting. Check the function name, parentheses, separators, referenced cells, and any circular-reference warning. The specific error code can help identify the cause.
How to prevent the problem next time
For cells intended to calculate, use General or an appropriate number format before entering formulas, and begin each expression with an equals sign. When copying formulas from a website, email, or text file, check for a leading apostrophe or unusual spacing. Keep an eye on the Show Formulas command when an entire sheet changes appearance, and use Automatic calculation unless the workbook has a specific reason to use Manual.
The key distinction is simple: formulas visible throughout a sheet usually point to a display toggle; formulas visible in isolated cells usually point to text entry or cell formatting; and unchanged results point to calculation mode or dependencies. Checking those possibilities in that order is a practical way to restore calculated values without disturbing the rest of the workbook.
Related
- How to Insert Speaker Notes in PowerPoint Step by Step
- Excel Often Not Responding? Causes, Fixes, and Prevention
- Free Yearly Expense Tracking Spreadsheet: Setup Guide
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Table Not Showing Filter Options? Fix ItIf an Excel table is not showing filter options, select a cell in the table and check Table…
- Excel MID Formula Not Working? Fix the Common CausesIf Excel’s MID formula is not working, first check that its arguments are in the right order: =MID(text,start_num,num_chars).…
- YEAR Function in Excel Not Working? Fixes That HelpIf Excel’s YEAR function is not working, first check that its argument is a real Excel date, not…
- Excel Spill Error When Creating a Table: Causes and FixesExcel shows #SPILL! when a dynamic-array formula tries to return results inside an Excel Table, because spilled arrays…
- Excel Insert Row Ruins My Formulas? Fix the ReferencesUsually, inserting a row in Excel does not ruin formulas: Excel adjusts references when you insert a worksheet…
- Why Is a Hyperlink Not Working in Outlook?A hyperlink may not work in Outlook because the link address is invalid, Windows has no working default…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.