Excel Formula Showing as Text? Fix It Fast

Errors & fixes · Updated November 19, 2026

If an Excel formula is showing as text instead of returning a result, first check whether Show Formulas is turned on; if only one or a few cells are affected, change their number format from Text to General and re-enter the formula. Also look for an apostrophe or space before the equals sign, which can make Excel treat an entry as plain text.

First check whether Excel is displaying every formula

If formulas appear across the worksheet wherever you expect results, Excel may be in Show Formulas view. This setting displays the formula in each formula cell rather than its calculated value; it does not convert the formulas into text or remove them. The worksheet can also look wider because formula strings take up more room than many results.

In Excel for Microsoft 365 on Windows, go to Formulas > Formula Auditing > Show Formulas to switch the display back to results. The Windows keyboard shortcut is Ctrl+`, where the grave-accent key is usually near the upper-left corner of the keyboard. On a Mac, use the Show Formulas command on the Formulas tab if the shortcut differs on your keyboard or is unavailable. If turning the setting off restores the values throughout the sheet, the formulas were working; only the display mode had changed.

This is a workbook display setting, not a cell-by-cell repair. If one cell still shows a formula after other cells return to normal, investigate that cell’s format and contents separately. The same applies if formulas show as text only in one column or in a newly pasted range.

Check the cell’s number format

A cell formatted as Text tells Excel to preserve what you type rather than interpret it as a formula. This commonly happens when a column was formatted before data entry, when a template uses Text format, or when values were pasted or imported from another system. The formula may look perfectly correct while remaining an ordinary text string.

  1. Select the affected cell or range.
  2. On the Home tab, open the Number Format list and choose General.
  3. Re-enter the formula so Excel parses it again. Select a cell, press F2, then press Enter. On a Mac, the function-key behavior can depend on keyboard settings; use the equivalent edit-and-confirm keys or edit the cell in the formula bar.

Changing Text to General alone often does not recalculate an existing text string. That is why the final re-entry step matters. For a small number of cells, editing and confirming each one is the clearest fix. For a large imported range, test a few cells first. Excel’s Data > Text to Columns command can sometimes convert formula-like text when you complete the wizard without splitting the contents, but conversion behavior depends on the data. Keep a copy of the original range before applying a bulk conversion.

For example, with numbers in A1:A3, the formula =SUM(A1:A3) adds those cells when Excel recognizes it as a formula. If the destination cell is Text-formatted, it may display the characters rather than the sum. Changing the format and re-entering the formula lets Excel evaluate it.

Look for an apostrophe, space, or other hidden character

A formula can be stored as text even when the cell is set to General if an apostrophe or another character comes before the equals sign. A leading apostrophe is a common way to force Excel to preserve text. It may not be obvious in the cell grid, so inspect the formula bar after selecting the cell. A leading space can have the same practical effect: Excel sees the space as the first character, not the equals sign.

Delete anything before the initial equals sign, then confirm the entry. Also consider nonbreaking spaces or other invisible characters in data copied from a web page, PDF, email, or external report. If the formula was assembled by concatenating imported text, inspect the source cells too; cleaning only the visible result may not address the underlying character.

There is a related but different case: an apostrophe can deliberately make a value beginning with an equals sign display as text. That is useful when documenting a formula in a worksheet, but it will not calculate. Remove the apostrophe only when you want Excel to evaluate the entry. Do not remove leading characters blindly from a whole column, because some apostrophes may be intentional text markers.

Confirm that the entry is a formula Excel can parse

Excel formulas normally begin with an equals sign as the first character. Check that the entry has not been preceded by a space, apostrophe, or other punctuation, and that the formula is not merely a description pasted into the cell. If Excel accepts the entry but shows its characters, text formatting or a leading character is more likely than a calculation problem. If Excel displays an error message instead, investigate the formula syntax or referenced data rather than treating it as a text-display issue.

For a simple example, with a number in A1 and another number in B1, =A1+B1 adds the two values. If A1 contains 3 and B1 contains 4, the result is 7. If the formula itself is visible in the cell, check Show Formulas, the cell format, and any leading character. If Excel shows an error such as a name or value error, the formula is being interpreted, but something in its expression or inputs needs attention.

Regional settings can also affect formulas that use function arguments. Some Excel configurations use semicolons instead of commas between arguments, depending on regional list-separator settings. The examples here use simple formulas that do not require argument separators, so that issue does not apply to them. When copying a formula with several arguments from a source that uses a different locale, Excel may reject it or request a corrected separator. That usually produces a parsing or formula error, not a worksheet-wide display of formulas as text.

Distinguish text display from calculation settings

Calculation mode controls when Excel updates formula results; it does not normally make formulas display as text. In Manual calculation mode, a cell may show an old result even though its formula is present. If values seem stale, check Formulas > Calculation Options and select Automatic if automatic recalculation is appropriate for the workbook. You can also use F9 on Windows to calculate open workbooks. Mac shortcuts can differ, so use Excel’s calculation command if the key combination is not available.

To tell the cases apart, select the cell and look at both the worksheet and formula bar. A visible formula string in the cell points toward Show Formulas or text storage. A numeric result that fails to update points toward calculation mode, dependencies, or an input that has changed. A displayed error indicates that Excel has evaluated something and found a problem; it is not the same as a formula stored as literal text.

Calculation settings can affect more than one workbook in a session, so do not switch modes without considering the workbook’s purpose. Large workbooks may use Manual mode to avoid lengthy recalculations during editing. If you change the setting, recalculate and review important results before relying on them.

Repair a column or imported range carefully

When many formulas in a range are text, first identify why. If the cells are Text-formatted, select the affected range, change it to General, and re-enter the formulas. If the entries have leading spaces or apostrophes, inspect a sample and remove only the unwanted characters. A blanket replace operation can alter legitimate text, so make a backup and test the replacement on a small subset before applying it broadly.

For a large range where every cell contains a formula-like string and there are no intentional text values, Text to Columns may be a practical conversion route. Select the range, choose Data > Text to Columns, proceed through the wizard without choosing delimiters that would split the formula, and finish. Check the result immediately; the command can affect cell contents, and the right outcome depends on how the source data is stored. If the range mixes formulas, labels, and other content, use a targeted method instead of converting everything at once.

  • Keep an unchanged copy of the source data before bulk edits.
  • Test the conversion on a few representative cells, including a formula with a range reference if one is present.
  • After conversion, compare the displayed results with expected values and inspect several formulas in the formula bar.
  • If only newly pasted data is affected, check the source format and the destination column format before repeating the paste.

Prevent the same issue when entering or pasting formulas

Set the destination cells to General before entering formulas, especially in a template or a column prepared for imported data. When pasting from another application, use a small test range first and confirm that the cells calculate. If you are bringing in a formula as text for documentation, keep it separate from cells intended to calculate so the two purposes are clear.

Be cautious when filling a range. If a formula works in one cell but the copied versions do not, check the destination cells’ formats and inspect whether the references changed as intended. A reference that moves when copied is not, by itself, evidence that Excel has stored the formula as text. Use absolute references where the calculation requires a fixed row or column, and verify the result against a simple known example.

Finally, distinguish a formula-display issue from a narrow column. A narrow column may show hash marks for some numeric values or cut off visible text, but it does not turn a result into a formula string. Widening the column may help readability; it will not correct Text formatting, Show Formulas, or a leading apostrophe.

Frequently Asked Questions

Why does Excel show the formula instead of the answer?
First check whether Show Formulas is enabled for the worksheet. If only selected cells show formulas, check whether they are formatted as Text or contain a leading apostrophe or space, then re-enter the formula.

Will changing a cell from Text to General fix the formula?
It changes how Excel treats future entries, but an existing text string may remain text. After selecting General, edit the cell and confirm the formula again so Excel can parse it.

Why does only one cell show a formula?
That cell may have been formatted as Text, pasted with a leading character, or entered differently from neighboring cells. Select it and inspect the formula bar and number format rather than changing the whole worksheet.

Why is the formula visible in every cell?
Show Formulas is a likely cause. Turn it off from Formulas > Formula Auditing > Show Formulas on Windows, or use the Show Formulas command on the Formulas tab on Mac. If only a few cells remain affected, check them individually.

Does Manual calculation make Excel show formulas as text?
No. Manual calculation can leave a result out of date, but it does not normally replace the result with the formula text. Check calculation mode for stale values and check display mode or cell contents when the formula itself appears.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.