If an Excel formula appears in the cell as text instead of producing a result, first check whether the cell is formatted as Text or the formula begins with an apostrophe or space. Change the cell format to General, then edit and re-enter the formula; if formulas across the sheet are showing, turn off Show Formulas.
First identify what Excel is displaying
A formula shown literally, such as a cell displaying the characters =A1+B1, is different from a formula that calculates to an unexpected value or an error such as #VALUE!. The first case usually means Excel is treating the entry as text or is displaying formulas intentionally. A calculation error, by contrast, means Excel recognized a formula but could not return the expected result.
Look at a few cells around the problem. If only one cell displays its formula, check that cell’s format and how the formula was entered. If every formula on the worksheet is visible, the Show Formulas setting is a more likely cause. If the formula appears to be a value but does not change when its inputs change, check calculation mode.
Also check the formula bar after selecting the cell. It can help reveal an apostrophe or leading space that is not obvious in the grid. An apostrophe entered before an equals sign tells Excel to store the following characters as text. A leading space can have a similar effect because the entry no longer begins with the equals sign Excel expects for a formula.
Fix a cell formatted as Text
When a cell is formatted as Text before you type or paste a formula, Excel may store the entry literally rather than evaluate it. Changing the format afterward does not necessarily convert the existing text into a working formula: you usually need to make Excel re-read the entry.
- Select the affected cell or range.
- On the Home tab, in the Number group, open the Number Format drop-down and choose General.
- Re-enter each formula. Select a cell, press F2, then press Enter on Windows. Alternatively, click in the formula bar, make a small edit, and press Enter. On a Mac, use the formula bar or double-click the cell to edit it, then press Return.
For a large range, changing the format alone may not be enough. After setting the cells to General, use Find and Replace to replace an equals sign with an equals sign in the selected range, if the workbook’s Find and Replace options are set to search formulas or values as appropriate. This forces Excel to process the entries again in many cases, but check the results before relying on it. The reliable method for a small number of cells is to edit and confirm each formula.
Do not confuse a Text format with a number format that merely changes how a result looks. A cell formatted as Currency can still contain a numeric result, while a formula entered into a Text-formatted cell may remain a text string. Setting General and re-entering the formula addresses the stored entry, not just its appearance.
Check the formula’s first character and syntax
A standard Excel formula begins with an equals sign as its first character. If the entry begins with an apostrophe, a space, or another character before the equals sign, Excel may treat it as text. Remove the extra character, then confirm the entry. An apostrophe used to force text may not appear in the cell itself, so inspect the formula bar if you suspect one.
Check that the formula also uses valid Excel syntax. For example, with the values 10, 20, and 30 in A1:A3 and the formula entered in B1, =SUM(A1:A3) returns 60. The range colon and closing parenthesis matter. If you copied a formula from a web page or another program, curly quotation marks, unusual spaces, or other typographic characters may have replaced ordinary formula characters.
Argument separators can differ with regional settings. Many Excel installations use commas between function arguments, while some use semicolons. If a formula is recognized as a formula but Excel reports a syntax problem, check the separator used by formulas that already work in that installation. This is distinct from a formula displayed literally as text, which more often points to cell format, an extra leading character, or Show Formulas.
Turn off Show Formulas
Show Formulas displays formulas in worksheet cells instead of displaying their results. It affects the worksheet view, not the formulas themselves, so you do not need to re-enter formulas if this setting was accidentally enabled.
In Excel for Microsoft 365 on Windows, select Formulas > Show Formulas to switch the view off. The Windows keyboard shortcut is Ctrl+` (the grave-accent key, often near the upper-left corner of the keyboard). On a Mac, use Formulas > Show Formulas; the shortcut can depend on the keyboard layout, so the ribbon command is the dependable option. When the setting is off, cells should show calculated results again, provided the formulas are valid and calculation is enabled.
If only one cell displays formula characters while neighboring formula cells show results, Show Formulas is less likely to be the cause because the setting applies to the worksheet view. Check that individual cell for Text formatting or a leading apostrophe instead.
Check calculation mode if results are stale
Manual calculation can make formulas appear not to update after their input cells change. It does not normally turn a formula into plain text: the cell generally continues to show its last calculated result until recalculation. This distinction helps avoid changing formats unnecessarily when the real issue is an old result.
On Windows, select Formulas > Calculation Options > Automatic. If the workbook is set to Manual, you can recalculate with F9; Ctrl+Alt+F9 forces a full recalculation of formulas. On a Mac, use Formulas > Calculation Options and choose Automatic. Function-key behavior can vary with Mac keyboard settings, so the ribbon commands are a clear alternative.
After switching to Automatic, change a source value and see whether dependent formulas update. If only one formula remains unchanged, inspect its references and whether it refers to the cells you intended. If the result updates but is still wrong, that is a formula logic or data issue rather than a text-display problem.
Know when a formula is meant to return text
Not every formula result is a number. Some functions deliberately return text, and a formula can calculate successfully while producing a text value that looks numeric. For example, with the number 12.5 in A1 and the formula in B1, =TEXT(A1,"0.00") returns the text 12.50. The result is formatted for display, but it is text rather than a number for later arithmetic.
If a result looks like a number but will not add or sort as expected, check whether the formula is intentionally using TEXT or whether the source data itself is stored as text. With text that contains a valid number in A2 and the conversion formula in B2, =VALUE(A2) returns the numeric value 25 when A2 contains the text 25. VALUE cannot convert arbitrary text, such as a word or an incompatible number format, so confirm that the source is a recognizable number.
Formatting a cell as Number does not turn text into a number by itself. Likewise, adding a currency symbol or changing decimal places cannot repair a formula that Excel never evaluated. Determine whether the formula is displayed literally, whether it returns a text result on purpose, or whether its inputs are text before choosing a fix.
A practical troubleshooting order
Use this sequence to avoid changing several settings at once. After each step, check whether the cell now shows the expected result:
- If all formulas are visible, turn off Formulas > Show Formulas.
- If just one or a few entries are visible as formula text, inspect the formula bar for an apostrophe or leading space.
- Set the affected cells to General, then edit and confirm the entries so Excel parses them again.
- If formulas show results that do not refresh, choose Automatic under Formulas > Calculation Options and recalculate.
- If the formula calculates but produces text or an unexpected value, check the function, its references, and the type of its inputs.
Keep a copy of the original workbook before applying broad Find and Replace changes or editing many cells at once. If the problem affects just one formula, test the fix in that cell first. If it came from a copied worksheet or imported file, inspect a few representative cells: pasted values can have different formats from the surrounding worksheet, and imported numbers may be stored as text.
Frequently Asked Questions
Why does Excel show the formula instead of the answer?
Usually the cell is formatted as Text, the entry starts with an apostrophe or space, or Show Formulas is enabled. For a single affected cell, set it to General and re-enter the formula. If many cells show formulas, check the Show Formulas setting first.
Will changing Text to General make the formula calculate?
Not always on its own. Changing the format affects future entry, but Excel may keep an existing entry as text. After changing to General, edit the cell and confirm the formula again so Excel evaluates it.
Why does a formula not update when I change a value?
Check Formulas > Calculation Options and select Automatic. In Manual mode, formulas can retain old results until recalculated. If just one result is wrong, also check the references in that formula.
Why does my formula return a number stored as text?
A formula such as TEXT is designed to return text, even when the displayed characters look numeric. If a source cell contains a number stored as text, convert the source appropriately or use VALUE when its contents are a valid number.
Does this advice also apply to Excel for the web?
The underlying causes—text-formatted cells, extra leading characters, and formulas displayed instead of results—are similar. Ribbon locations and available keyboard shortcuts can differ in the browser; use the relevant Home or Formulas ribbon commands and re-enter the formula after changing its format.
Related
- Excel Consolidate Rows and Sum Data: A Practical Guide
- Excel Consolidate Multiple Tables into One Workbook
- Excel Consolidate Multiple Sheets: Steps and Options
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- SUMIFS Not Working With Blanks? Fix the CriteriaWhen you want to sum rows whose criteria cells are blank, use an explicit empty-string criterion: with categories…
- IRR Formula Not Working in Excel? Causes and FixesThe IRR formula usually fails because the cash-flow range is incomplete or contains no valid positive-and-negative combination, the…
- Excel Stop Circular Reference Warning? Fix or Allow ItTo stop an Excel circular reference warning, first remove the formula loop using Formulas > Error Checking >…
- Excel Worksheet Not Scrolling? Fix the Most Likely CausesIf an Excel worksheet will not scroll, first check whether Scroll Lock is on, then look for frozen…
- Excel VLOOKUP Spill Error: Causes and FixesAn Excel VLOOKUP spill error, shown as #SPILL!, means the formula is returning multiple results but Excel cannot…
- Excel Find and Replace Not Working? Fix the Common CausesIf Excel Find and Replace is not working, first check the search scope and the options in the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.