Excel Shows a Formula as Text? Separate Display Mode from Cell Format

By ON Lab · Sources checked November 6, 2026

In Excel for Windows desktop, distinguish a worksheet showing formulas from a cell storing a formula as text. Check Formulas → Show Formulas for the view state. For an intended formula in a Text-formatted cell, Microsoft's guidance is to choose General, then press F2 and Enter so Excel reads the entry again.

Identify which symptom you have

A recent Excel reader reported a SUM cell acquiring Text format and later displaying the formula as a text string. The reader asked whether this was formatting propagation or a bug. That report does not establish a confirmed root cause, but Microsoft's documentation supports checking display mode and cell format separately.

Keep an unchanged workbook or working copy before editing a large range. Start with one affected formula cell. Do not convert an entire column of identifiers, dates or intentionally literal text just because one calculation looks wrong.

1. Check whether the worksheet is displaying formulas

On the Formulas tab, inspect Show Formulas. Microsoft describes it as a toggle between formulas and their calculated results. If formulas are being displayed throughout the sheet and you want results, switch back to the results view.

This changes what is displayed; it does not turn a text string into a working formula. Do not repeatedly retype formulas across the sheet when the real issue is simply the view setting. Microsoft also documents Ctrl plus the grave-accent key as the display toggle, but the ribbon can be easier to identify on different keyboard layouts.

Seeing a formula in the formula bar while its cell shows a result is normal. Do not confuse the formula bar with the value shown inside the worksheet cell.

2. Inspect one intended formula cell's format

Select the affected cell and read its actual entry.
Confirm that it is intended to calculate, rather than display an example formula as plain text.
Right-click and open Format Cells.
Choose General and confirm.
With that cell selected, press F2, then Enter.
Inspect the resulting cell and formula bar again.

The re-entry step matters. Changing the format alone may leave an existing entry treated as text. Microsoft's troubleshooting explicitly pairs General format with F2 and Enter.

Confirm that an intended formula begins with an equal sign. A literal entry such as SUM(A1:A3) without the leading = is not the same as =SUM(A1:A3). Read the entry before changing it; intentional formula examples should remain text.

3. Use a small known calculation to separate the problem

In an empty cell of a disposable test copy, use General format and enter =2+3. In results view, the expected arithmetic result is 5. This example isolates basic formula recognition from the contents of a complicated source range.

If the small calculation works but a SUM result is zero or unexpected, inspect the SUM range and data types as a separate issue. Making a formula calculate does not establish that the referenced cells contain the intended numbers. A column of text identifiers should not automatically be converted to numbers.

If the test still displays the literal formula, recheck the display state and the actual entry instead of replacing many production cells. Record what the formula bar and cell show.

4. Prevent accidental recurrence without changing unrelated data

For a new intended formula, choose the appropriate non-text format before typing it. When copying a formula to another location, inspect the destination's formatting and the resulting calculation. A cell's familiar appearance does not prove that its entry was recognized as a formula.

Do not use Paste values only merely to hide this symptom. That operation creates a static result and removes the calculation relationship. It is appropriate for a deliberate snapshot, as explained in the separate values-versus-formulas guide for Sheets, but it is not the same job as restoring an intended Excel calculation.

Similarly, do not change the workbook to manual calculation simply to suppress updates. A stale calculated value is a different condition from a formula stored as text. Microsoft's broader troubleshooting covers calculation mode when that separate symptom applies.

5. Save and reopen the checked workbook

Save the intended working copy, close it and reopen that exact file. Recheck the affected cell's formula, display state and result. Verify important dependent outputs too, because the disappearance of a visible text string alone is not a calculation audit.

On a disposable copy, you can change a known input and observe whether the intended formula responds, then restore the test input. Do not modify live source data simply to demonstrate that a formula updates.

If formatting changes unexpectedly again

Keep a small non-sensitive example showing the source cell format, destination format, exact formula and sequence that reproduces the behavior. Include the Excel version and operating system when requesting support. This guide does not confirm why the recent reader's format changed or promise to prevent every automatic-formatting issue.

Completion means that an intended formula is recognized, shown in the desired view, and checked after saving and reopening. It does not certify the workbook's business calculations or imply that the Windows desktop controls are identical in every web or mobile edition. No private workbook or reader's device was accessed to prepare this source-based guide.