Excel Formula Appearing as Text? Fix It Now

Errors & fixes · Updated November 22, 2026

If your Excel formula appears as text instead of calculating, the most common cause is that the cell is formatted as Text before you entered the formula. To fix it, select the cell, change the number format to General, then re-enter the formula by pressing F2 and Enter (or retype it).

Why Does Excel Show the Formula as Text?

Excel treats a cell as either a value, a formula, or text. When you type something that starts with an equals sign (=), Excel normally interprets it as a formula. But if the cell’s number format is set to Text, Excel will display exactly what you type, including the equals sign, as literal text. This is the most frequent reason. Other causes include:

  • Leading apostrophe: If you type an apostrophe (‘) before the equals sign, Excel treats everything after it as text. The apostrophe is invisible in the cell but shows in the formula bar.
  • Missing equals sign: If you forget the =, Excel won’t calculate. For example, typing SUM(A1:A5) without the = is just text.
  • Space before equals: A leading space makes Excel treat the entry as text.
  • Cell formatted as Text via the ribbon: Selecting a range and choosing Home > Number Format > Text before typing will force text.

How to Fix a Single Cell or a Few Cells

Here’s the quickest way to correct one or a few cells that are showing formulas as text:

  1. Select the cell(s) with the text-formula.
  2. On the Home tab, in the Number group, change the format from Text to General.
  3. Click into the formula bar (or press F2) and press Enter. This forces Excel to re-evaluate the cell.

If that doesn’t work, delete the cell contents and retype the formula from scratch. Also check for an invisible apostrophe: click the cell and look in the formula bar—if you see a leading apostrophe, remove it.

How to Fix an Entire Column or Large Range

For a whole column of text-formulas, you can use the Text to Columns feature, which forces Excel to reinterpret the data:

  1. Select the column with the text formulas.
  2. Go to Data > Text to Columns.
  3. In the wizard, choose Delimited and click Next.
  4. Uncheck all delimiters (or just leave them as is) and click Next.
  5. In the last step, choose General for the column data format, then click Finish.

This works because it forces Excel to convert each cell from text to a general format, and the formulas will then calculate. On a Mac, the path is Data > Text to Columns.

Preventing the Problem: Best Practices

To avoid this issue in the future, follow these habits:

  • Always type the equals sign first, with no spaces before it.
  • Before entering formulas in a new range, set the number format to General (Home > Number Format > General).
  • If you copy formulas from a web page or email, they may come with hidden characters. Paste using Paste Special > Values, then re-enter the formula.
  • Never use the apostrophe trick unless you intentionally want text.

Common Misconceptions and Related Issues

Misconception: “The formula is correct but shows as text because of the formula bar.” Actually, if the formula bar shows the formula but the cell shows a result, that’s normal—the formula bar always shows the underlying formula. The problem is when the cell itself displays the formula text.

Related issue: Sometimes formulas show as text because the workbook is in Manual Calculation mode. That’s different: the cell shows the last calculated result, not the formula text. To check, go to Formulas > Calculation Options and ensure it’s set to Automatic.

Frequently Asked Questions

Why does my Excel formula show as text after I copy it from another sheet?

When you copy a cell that is formatted as Text, the format comes with the paste. To fix, select the pasted cells, change format to General, and re-enter the formulas (F2 then Enter for each, or use Text to Columns).

How do I fix formulas showing as text in Google Sheets?

Google Sheets works similarly. If a formula shows as text, check for a leading apostrophe or space. Also, ensure the cell format isn’t set to Plain text (Format > Number > Automatic). Then re-enter the formula.

Can I use a formula to convert text-formulas into real formulas?

Yes, but it’s a bit advanced. If your text is in A1, you can use =VALUE(A1) if it’s a number, but for a formula string you’d need to use a VBA macro. A simpler approach is to use the Text to Columns method above.

Why does Excel show the formula in the cell but not calculate it even after changing format to General?

This usually means the cell still contains a leading apostrophe or space. Delete the cell content and retype the formula. Also, check if the cell is part of a table with a calculated column that might be overriding.

When All Else Fails: Use Find & Replace

If you have many cells with formulas as text, you can use Find & Replace to strip out a leading apostrophe or space. For example, to remove a leading apostrophe:

  1. Select the range.
  2. Press Ctrl+H (Cmd+H on Mac) to open Find & Replace.
  3. In Find what, type an apostrophe (‘) but note that Excel might not find it in the cell because it’s invisible. Instead, use a space if that’s the issue.
  4. Replace with nothing, then click Replace All.

This works for spaces but not for apostrophes because Excel treats the apostrophe as a format marker. For apostrophes, you’ll need to use a VBA macro or manually re-enter.

Conclusion

In most cases, the fix is simple: set the cell format to General and re-enter the formula. If that doesn’t work, check for hidden characters. With the steps above, you’ll have your formulas calculating in no time.

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.