How To Fix Excel Formulas Not Calculating Or Showing Text (2026)

When an Excel cell shows the formula itself, or keeps an old result, the cause is almost always one of a few settings.

Which one applies depends on what you see in the cell, so the table below matches the symptom to the fix.

The steps come from Microsoft’s support pages, and none of them require changing the formula itself.

Quick answer: match the symptom to the fix

What you seeLikely causeFix
Every formula on the sheet shows as textShow Formulas is onFormulas tab > Show Formulas, or Ctrl + `
One cell shows the formula textCell is formatted as TextFormat Cells > General, then F2 and Enter
Results do not update when you change a numberCalculation is set to ManualFile > Options > Formulas > Automatic
The cell shows SUM(A1:A10) as plain textNo leading equal signStart the entry with =
Dates appear as numbersWrong number formatPick a Date format in the Number Format gallery

Turn off Show Formulas

If every formula on the sheet displays instead of its result, Show Formulas is probably switched on.

  1. Select the Formulas tab.
  2. In the Formula Auditing group, select Show Formulas to switch it off.

You can also press Ctrl + ` (the grave accent key) to toggle between formulas and results.

Microsoft notes this setting affects the whole sheet, so it is the first thing to check when many cells look wrong.

Fix a cell formatted as Text

A formula typed into a cell formatted as Text is stored as plain text and never calculates.

  1. Right-click the cell and select Format Cells > General, or press Ctrl + 1.
  2. Press F2 to edit the cell.
  3. Press Enter.

Changing the format alone is not enough, which is why the F2 and Enter step matters.

Fix a large range formatted as Text

Editing cells one by one is slow when a whole column is affected.

  1. Select the range.
  2. Apply the number format you want.
  3. Go to Data > Text to Columns, then select Finish.

Microsoft lists this as the way to convert a large range in one go.

Check the cells your formula refers to

A formula can also fail because the cells it points at are formatted as Text.

  1. Select the referenced cell.
  2. On the Home tab, expand the Number group, or press Ctrl + 1, and select General.
  3. Press F2, then Enter.

Repeat for any other referenced cells that hold numbers stored as text.

Start the formula with an equal sign

An entry without a leading equal sign is not calculated.

Typing SUM(A1:A10) shows that text, while typing =SUM(A1:A10) returns a result.

Check the first character of the cell before trying anything more involved.

Switch calculation back to Automatic

Microsoft states that formulas will not calculate if manual calculation is enabled.

  1. Select File > Options > Formulas.
  2. Under Calculation options, set Workbook Calculation to Automatic.
  3. Select OK.

You can also use the Formulas tab, open Calculation Options in the Calculation group, and choose Automatic.

Calculation modeWhen Excel recalculates
Automatic (default)After every change to a value, formula or name
Automatic except data tablesOn any change, but data tables only when changed directly
ManualOnly when you trigger it, such as with F9

Recalculate right now

If you need a fresh result while still in Manual mode, use one of these shortcuts.

ShortcutWhat it does
F9Recalculates changed formulas and their dependents in all open workbooks
Shift + F9Does the same for the active worksheet only
Ctrl + Alt + F9Recalculates all formulas in all open workbooks, changed or not
Ctrl + Shift + Alt + F9Checks dependent formulas, then recalculates all formulas in all open workbooks

The Formulas tab also has Calculate Now for all open worksheets and Calculate Sheet for the active one.

Why Excel switched to Manual by itself

Microsoft explains that all open workbooks share one calculation mode.

The first workbook you open sets the mode, and any workbook opened afterward uses that same mode.

So opening a Manual workbook first can switch every other file you open that session to Manual.

Changing the mode in any open workbook changes it for all of them.

Microsoft’s workarounds are to close other workbooks before opening one that needs a different mode, or to set the open workbook to the mode you want first.

What happens to the mode when you save

Excel saves whatever mode is active at that moment, not the mode the file was originally in.

Microsoft’s example is opening an Automatic workbook first and a Manual one second, then saving the Manual file, which immediately saves it as Automatic.

That is why a workbook can quietly change behavior after being opened alongside another file.

SituationMode Excel uses
Several workbooks open at onceThe mode of the first workbook opened
New blank workbook after closing everythingThe mode of the documents you just closed
New workbook from a templateThe mode specified in the template
Workbook saved in an earlier Excel versionFully recalculated on open, unless the mode is Manual

Choosing Manual also turns on Recalculate workbook before saving, which you can clear if saving becomes slow.

If the formula bar is empty instead

A different problem is a formula that is hidden from the formula bar.

That happens when the cells have Hidden checked on the Protection tab and the sheet is protected.

  1. Select Review > Unprotect Sheet.
  2. If Unprotect Sheet is unavailable, turn off the Shared Workbook feature first.
  3. Right-click the cells, select Format Cells, and clear Hidden on the Protection tab.

If Excel itself is misbehaving, try repairing Microsoft 365 apps on Windows 11.

Lost work is covered in how to recover an unsaved Excel workbook.

For a workbook you cannot edit, see how to fix Excel file locked for editing.

Sources

Leave a Reply

Your email address will not be published. Required fields are marked *