If Excel displays a formula in the cell instead of its result, first check whether Show Formulas is turned on; if it is not, change the cell format to General and re-enter the formula. A leading apostrophe or space can also make a formula behave like text, so the right fix depends on whether the issue affects one cell or the whole worksheet.
Quick diagnosis: what are you seeing?
Look at the cell and the formula bar, then compare the problem with nearby cells. These clues help distinguish a display setting from a formula stored as text:
- Many formulas are visible across the worksheet: Show Formulas may be enabled. Column widths may expand because formulas take up more space than results.
- One or a few cells show formula characters: The cells may be formatted as Text, or the entries may start with an apostrophe or an invisible space.
- The cell shows a number or an error, but not the expected answer: Excel is probably calculating the formula; investigate its logic, references, or calculation settings instead.
- The formula bar shows a formula but the cell looks blank: The result might be an empty string, white font on a light background, or a hidden display caused by the cell’s number format.
One useful test is to select a problem cell and inspect the formula bar. If the formula bar contains the formula and the worksheet displays the same characters, either Show Formulas or text storage is likely. If the formula bar contains only the entered characters and the cell is Text-formatted, re-entering the formula after correcting the format is usually necessary.
How Excel distinguishes formulas from text
Excel normally recognizes an entry beginning with an equals sign as a formula and calculates it. For example, a formula can add two cell values. With 12 in A2 and 8 in B2, enter =A2+B2 in C2; the result is 20. If Excel treats that entry as text, it preserves the characters instead of evaluating the expression.
Cell formatting can influence how Excel interprets an entry at the time it is entered. A cell set to Text is intended to preserve characters exactly, which is useful for product codes, account-like identifiers, and strings that begin with symbols. But if a cell is already Text-formatted when you type a formula, Excel may store the formula characters as text. Changing the format afterward does not necessarily make Excel reinterpret what is already stored.
This distinction explains why simply choosing General may not fix an existing entry. Format the cell as General, then edit and confirm the entry again so Excel parses it anew. The formula must begin with an equals sign, with no apostrophe or other character placed before it.
Turn off Show Formulas
Show Formulas changes the worksheet view so formulas appear in cells instead of their calculated results. It does not turn formulas into text or stop calculation; it changes what the sheet displays. Because the setting can affect a whole worksheet, it is the first thing to check when many formulas suddenly appear at once.
In Excel for Microsoft 365 on Windows, go to Formulas > Formula Auditing > Show Formulas to toggle the view off. The Windows keyboard shortcut is Ctrl+` (the grave-accent key, often located near the upper-left corner of the keyboard). Pressing it again toggles formula display back on. The apostrophe-like key used for this shortcut is not the same as a straight quotation mark.
On Excel for Mac, use the Show Formulas command on the Formulas tab if it is available in the ribbon. Keyboard mappings can vary with the keyboard layout; use the ribbon command if the Windows shortcut does not work. In Excel for the web, look for Show Formulas on the Formulas tab, noting that the ribbon layout can differ from the desktop app.
After switching back, check whether the values return. If only particular cells continue to show formula characters, the view setting was not the whole problem: inspect their number format and the characters before the equals sign.
Fix cells formatted as Text
For a small number of cells, use this sequence in Excel for Windows:
- Select the affected cell or cells.
- On the Home tab, open the Number Format list and choose General.
- Enter edit mode by pressing F2, then press Enter to confirm the formula again. You can also click in the formula bar and press Enter.
On Mac, select General from the number-format controls on the Home tab, then edit and confirm the entry. The key used to edit a cell can depend on the keyboard and settings; clicking the formula bar is an alternative. The important part is to make Excel read the entry again after changing its format.
For example, suppose A2 contains 12 and B2 contains 8, and C2 is incorrectly formatted as Text. After changing C2 to General, re-enter =A2+B2. Excel should calculate 20. If you only change the format and do not re-enter the formula, C2 may continue to display the literal characters.
When many imported cells are affected, try the correction on a copy or a small sample first. In Windows desktop Excel, Data > Text to Columns can sometimes convert text-like entries when you complete the wizard with the appropriate settings. Its results depend on the data and options selected, and it can split or transform data, so inspect the preview and preserve a backup before applying it to a large range. For a small selection, re-entering cells individually is slower but easier to verify.
Look for apostrophes, spaces, and imported characters
An apostrophe entered before a formula tells Excel to keep the following characters as text. The apostrophe may not appear in the cell itself, but it can be visible in the formula bar or when you edit the entry. Delete it, make sure the cell is not Text-formatted, and confirm the formula again.
Leading spaces can create a similar problem. An entry with a space before the equals sign is not the same as a formula that starts with the equals sign. This can happen when information is pasted from a website, a text file, or another program. Click into the formula bar, remove anything before the equals sign, and press Enter.
Copied data can also contain nonbreaking spaces or other characters that look like ordinary spaces. If a formula still behaves as text after removing a visible space, clear the cell and type the formula directly as a test. If that works, the pasted content likely included an extra character or formatting. Avoid removing characters in bulk until you have checked a sample: spaces and leading apostrophes may be meaningful in codes or imported text.
Check formula syntax and argument separators
A formula needs valid syntax as well as the correct starting character. Check that parentheses are balanced, cell references are valid, and text values are enclosed in straight double quotation marks when required. For instance, with a person’s status in A2, a valid comparison formula is =IF(A2="Paid","Complete","Due"). If A2 contains Paid, the result is Complete. The layout assumed here is a status value in A2 and the formula in another cell.
Excel’s regional settings can affect the list separator between function arguments. Many installations use commas, while some use semicolons. If a formula is rejected or interpreted unexpectedly after being copied from another locale, check the separator used by formulas that already work in that installation. Do not replace separators blindly in a workbook; separators inside quoted text are not argument delimiters.
Also distinguish formula text from an error message. A misspelled function or invalid reference usually produces an error such as a name or reference error rather than displaying the entire formula literally. If the cell shows an error value, Excel has generally recognized an expression and is reporting a different problem. Use the error and the formula bar to choose the next troubleshooting step.
When the result is stale or calculation is manual
Manual calculation is a common source of confusion, but it usually causes an old result to remain visible, not the formula characters to appear. To check the setting in Windows Excel, open Formulas > Calculation Options and see whether Automatic is selected. Mac desktop Excel also has Calculation Options on the Formulas tab, though the ribbon layout may differ.
If a workbook is set to Manual, formulas may update only when calculation is requested. Press F9 in Windows to calculate open workbooks, or use the calculation commands on the Formulas tab. On Mac, use the calculation command in the ribbon or the shortcut shown in Excel’s menus for that version. Calculation mode can affect a workbook’s responsiveness and timing, so do not change it casually in a large or carefully controlled model.
If the cell displays a plausible but outdated number, check calculation mode and dependencies. If it displays the formula characters themselves, return to Show Formulas, Text formatting, and leading characters. The two symptoms look related but have different causes.
Prevent the problem in imported and shared workbooks
When building a workbook that will receive formulas, set the destination cells to General before entering or pasting formulas. If a template uses Text formatting to preserve identifiers, keep formula cells separate from those text fields. This avoids changing formats later and makes it clearer which cells should calculate.
When importing a CSV or copying from an external source, inspect a few rows before applying fixes to the full dataset. A column of codes may correctly need to remain text, while a neighboring calculated column should be numeric or General. Excel may also infer types during import, so review the import settings and the resulting cell formats rather than assuming every column should be converted.
For shared workbooks, ask whether another person intentionally enabled Show Formulas for auditing. The view can be useful for reviewing calculations, and it does not change the underlying formula results. If the workbook opens with formulas displayed for everyone using that sheet, toggle the view off when finished, then save if appropriate. Avoid editing formulas simply because they are visible: first establish whether the display mode changed.
Frequently Asked Questions
Why is Excel showing the formula instead of the result in one cell?
That cell may be formatted as Text, begin with an apostrophe or space, or contain pasted characters before the equals sign. Set it to General, remove any leading characters, and re-enter the formula.
Why are all my formulas showing in Excel?
Show Formulas is likely enabled for the worksheet. Toggle it off from Formulas > Formula Auditing > Show Formulas in Windows Excel, or use the Show Formulas command on the Formulas tab.
Will changing Text to General automatically calculate an existing formula?
Not always. Excel may retain the entry as text until it is edited and confirmed again. After changing the format, press F2 and Enter in Windows, or edit through the formula bar and confirm the entry.
Why does Excel show an old answer instead of updating?
The workbook may use Manual calculation, or the formula may depend on inputs that have not changed as expected. Check Formulas > Calculation Options and select Automatic if that is appropriate for the workbook.
Does Show Formulas change or damage my formulas?
No. It changes the worksheet display so formulas are visible in place of their calculated results. Turning it off restores the usual result display; it does not rewrite the formulas.
Related
- Excel Reverse Undo Shortcut: What Works and What Doesn’t
- Excel Reverse Worksheet Order: How to Do It
- Excel Repair Software Free Full Version: What Works?
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Keeps Doing Text to Columns? Causes and FixesExcel does not normally rerun Text to Columns on its own. If data keeps splitting, a CSV or…
- Excel Hyperlink Not Working After Copying? Causes and FixesIf an Excel hyperlink stops working after you copy it, first check whether the paste kept the hyperlink…
- Excel RATE Function Not Working? Fix Common ErrorsIf Excel’s RATE function is returning an error or an unexpected number, check that the cash-flow signs are…
- Excel Data Table Not Working? Fix the What-If ToolIf an Excel What-If Analysis data table is not working, first check that its output formula and test…
- COUNTIFS Excel Error? How to Find and Fix Common CausesA COUNTIFS error is usually caused by criteria ranges with different dimensions, invalid criteria syntax, or references that…
- Which One Is Not an Aggregate Function? SQL GuideA scalar function such as UPPER() is not an aggregate function: it transforms a value in an individual…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.