If Excel is showing formulas instead of their results, turn off Formulas > Formula Auditing > Show Formulas or press Ctrl+` on Windows. If only one cell is affected, check whether it is formatted as Text; if results are outdated, check the calculation mode under Formulas > Calculation Options.
First, identify what Excel is displaying
The right fix depends on whether you can see a formula, a blank, an old answer, or an error. Look at the cell itself and the formula bar above the worksheet. If the formula bar contains a formula but the cell shows something different, the value may be hidden by formatting or the column may be too narrow. If the formula bar contains the same formula text you see in the cell, Excel may be treating it as text or displaying formulas for the whole sheet.
- Formulas appear in many cells: check the Show Formulas setting.
- One cell displays a formula as text: check its number format, leading apostrophe, or extra characters.
- A previous answer remains visible: check calculation mode and recalculate.
- The cell looks empty: the formula may return an empty string, or formatting may hide its result.
- You see an error or hash marks: investigate the error or widen the column, rather than changing calculation settings first.
Make a copy before making broad changes to a workbook, especially if it contains carefully designed number formats or formulas. The checks below start with the most common causes and move toward less obvious ones.
Turn off Show Formulas
Show Formulas is a worksheet display setting. When it is on, Excel displays formulas in cells instead of their calculated results. It can be useful for reviewing a sheet, but it can make a whole worksheet look as though every formula has stopped working.
- Open the Formulas tab.
- In the Formula Auditing group, select Show Formulas to switch it off.
On Windows, Ctrl+` toggles Show Formulas. The backtick key is often near the upper-left corner of a US keyboard, below Esc; its position can differ on other layouts. On a Mac, use the Show Formulas command on the Formulas tab if the shortcut is unavailable or differs with your keyboard layout. This setting applies to the active worksheet, so check other sheets separately if they also display formulas.
Show Formulas changes what Excel displays, not the underlying formulas or their results. Once switched off, the results should return if the formulas are valid and calculation is working. If a particular cell still shows formula text, continue with the cell-format checks below.
Check whether the cell is formatted as Text
A cell with the Text number format can store an entry such as a formula as literal text instead of calculating it. This commonly happens when a cell or column was formatted as Text before the formula was entered, or when data was pasted in from another source. Changing the format afterward does not always make Excel reinterpret the existing entry automatically.
- Select the affected cell or range.
- On the Home tab, open the Number Format drop-down and choose General.
- Re-enter the formula: select the cell, press F2 on Windows, then press Enter. You can also click the formula bar, make a small edit, and press Enter.
For example, with a quantity in B2 and a unit price in C2, the formula =B2*C2 multiplies those values. If B2 contains 4 and C2 contains 12, the calculated result is 48. If the cell containing the formula was set to Text before entry, Excel may display the characters =B2*C2 rather than 48. Set the cell to General and re-enter the formula to prompt Excel to calculate it.
On Mac, the ribbon also has a number-format control on the Home tab. If an F-key shortcut does not behave as expected, use the formula bar or double-click the cell to edit it, then press Return. Function-key behavior can depend on the Mac keyboard settings.
Look for an apostrophe, space, or missing equals sign
Excel calculates a formula when it recognizes the entry as a formula. A leading apostrophe tells Excel to treat the following content as text. A leading space can also prevent an entry from being recognized as intended, and an expression without an initial equals sign is generally treated as ordinary text. These characters may be hard to notice in the grid, so inspect the formula bar or edit the cell.
Delete any unintended apostrophe or leading spaces, make sure the entry begins with an equals sign, and press Enter. Do not remove an apostrophe automatically if the cell is meant to display formula instructions or other literal text; the apostrophe may be there deliberately. If the formula was imported from a text file, also check for unusual spaces or characters copied along with it.
A related issue is a formula that looks syntactically plausible but uses the wrong argument separator. Many Excel installations use commas between function arguments, while some regional settings use semicolons. If Excel rejects a formula or treats it unexpectedly, use the separator accepted by your installation. This is separate from Show Formulas: changing display settings will not correct a formula-entry or regional-separator issue.
Check calculation mode and recalculate
Excel can calculate workbooks automatically or wait for a manual recalculation. If calculation is set to Manual, a formula may continue showing an earlier result after its input cells change. In Microsoft 365 for Windows, check Formulas > Calculation Options > Automatic. Calculation mode can affect other open workbooks too, so after switching to Automatic, check whether the formulas update.
If the workbook is already set to Automatic but a result still appears stale, ask Excel to calculate again. Press F9 on Windows to recalculate open workbooks. Ctrl+Alt+F9 forces a full calculation of formulas, including formulas Excel might otherwise consider unchanged. On Mac, use Formulas > Calculate Now where available; keyboard shortcuts can vary by keyboard and system settings.
Recalculation can take time in a large workbook, especially one with many linked formulas or data connections. It can also update values based on volatile functions or changed inputs, so review important results afterward. Automatic calculation updates formulas when relevant values change; it does not fix a formula that contains an error, points to the wrong cells, or is stored as text.
Find results hidden by formatting or column width
Sometimes a formula is calculating correctly but its result is difficult to see. First select the cell and inspect the formula bar. Then check the cell’s number format and font settings, as well as the width of the column. A custom number format or a font color matching the cell fill can make a displayed result look blank. Conditional formatting may also change the font or fill when a rule is met.
A column that is too narrow can show hash marks instead of a number, particularly for dates and times. Select the column and use Home > Format > AutoFit Column Width, or drag the boundary at the right edge of its column heading. Hash marks usually indicate a display-width or format issue, not a formula that needs to be rewritten. Text may instead spill into an empty neighboring cell, but will be cut off if the next cell contains content.
Excel can also be configured not to display zero values in a worksheet. If a formula’s result is zero but the cell looks blank, check File > Options > Advanced on Windows and look for the worksheet display setting for zero values. The setting is worksheet-specific. On Mac, the Options interface differs; inspect Excel’s settings for the worksheet’s display options. Also check for a custom number format that hides zero values before concluding that the calculation failed.
Check whether the formula is designed to return a blank
A blank-looking result can be the intended output. For example, a formula may use an IF test to leave a cell empty until an input is provided. With a status in A2 and a result in B2, =IF(A2="","",B2) returns an empty string when A2 is empty; if A2 contains a value, it returns the value in B2. The formula is working in either case. Select the cell and inspect the formula bar to tell an empty-string result from a genuinely empty cell.
Some other possibilities are that a formula returns zero and zeros are hidden, a conditional format makes the result hard to see, or the formula references an empty cell. Before replacing a formula, check its inputs and its logic. Removing a condition designed to keep a report uncluttered can cause unwanted zeros or messages to appear throughout the worksheet.
Understand errors and distinguish them from missing results
An error value is a result: it means Excel evaluated a formula but could not return the expected value. The specific error usually points toward the kind of issue. For example, #DIV/0! can occur when a formula divides by zero or a blank cell, while #NAME? can indicate text Excel does not recognize in a formula. #VALUE! can signal an incompatible value or argument. Check the formula and the cells it references before wrapping it in error-handling logic.
If you see #SPILL!, a dynamic-array formula may need space to place its results. Inspect the cells in the intended output area for existing content or other obstructions. If you see #REF!, a reference may have been deleted or become invalid. These errors are different from a formula being displayed as text: Show Formulas and cell formatting will not repair broken references, invalid inputs, or a blocked spill range.
A practical troubleshooting order
To avoid changing several settings at once, test one likely cause at a time. Start with the scope of the problem: if every formula on one sheet is visible as text, check Show Formulas; if only one cell is affected, check that cell’s format and entry. Then move on to calculation, display formatting, and formula logic.
- Check whether the whole worksheet or just one cell is affected.
- Turn off Show Formulas if formulas appear across the sheet.
- For a single formula shown as text, set the cell to General and re-enter it.
- Check for an unintended apostrophe, leading space, or missing equals sign.
- Set calculation to Automatic and recalculate if an answer is stale.
- Inspect column width, number formats, font color, conditional formatting, and zero-value display if the cell looks blank or shows hash marks.
- Read any error value and check the inputs and references it identifies.
After each change, verify the result in the cell and, when useful, in the formula bar. This helps distinguish a display-only issue from a calculation or formula problem and reduces the risk of altering a workbook setting that was intentional.
Frequently Asked Questions
Why is Excel showing formulas in every cell?
Show Formulas is probably enabled for that worksheet. Turn it off from Formulas > Formula Auditing > Show Formulas, or press Ctrl+` on Windows.
Why does Excel show the formula instead of the answer in one cell?
The cell may be formatted as Text, or the entry may begin with an apostrophe or space. Change the format to General, then edit and re-enter the formula.
Why is my formula result not updating when I change a value?
Check whether calculation is set to Manual under Formulas > Calculation Options. Choose Automatic and recalculate if needed.
Why does my formula cell look blank?
The formula might return an empty string, return zero while zero display is disabled, or have text that is hidden by formatting. Select the cell and inspect the formula bar and number format.
What does ###### mean in an Excel cell?
It often means the column is too narrow to display the formatted number or date. Widen the column or use AutoFit Column Width, then check whether the value becomes visible.
Related
- Excel Data Model: Can You Turn It Off?
- Excel Data Model and SharePoint: How They Work
- Excel Data Model on Mac: What Works and What Doesn’t
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Data Validation Not Working? Fix Common IssuesIf Excel data validation is not working, first select an affected cell and open Data > Data Validation…
- COUNTA Not Working in Excel? Causes and FixesCOUNTA often seems not to work because it counts every cell that is not truly empty—including cells with…
- Google Sheets Filter Not Filtering? Fix the Common CausesIf a Google Sheets filter is not filtering, check that the filter covers the full data range, that…
- VLOOKUP Between Sheets Not Working? How to Fix ItIf VLOOKUP between sheets is not working, check that the lookup value is in the first column of…
- SUMIF Not Working With Merged Cells? Causes and FixesYes—merged cells can make SUMIF appear not to work because Excel stores a merged area’s value only in…
- Excel SUM Ignore #N/A Errors: Practical Fixes and FormulasYes. In Microsoft Excel for Microsoft 365, if the values to total are in B2:B10, use =SUM(IFNA(B2:B10,0)) to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.