Ctrl+` shows formulas — how do I turn off?

Press Ctrl+` again or Formulas → Show Formulas to return to calculated values.

Apostrophe before = in CSV imports?

Remove leading apostrophe or use Text to Columns on General format, then re-enter the formula.

Downstream cells may be formatted as Text. Set the column to General and fill down again.

Excel troubleshooting

Fix Excel cells that display the formula text instead of the calculated result by checking cell format, show formulas mode, and leading spaces.

Excel displays formula text when the worksheet is in Show Formulas mode, the cell is formatted as Text, or the formula was entered with a leading space.

Turn off Show Formulas, set the cell to General format, delete any leading space before the equals sign, and re-enter the formula.

Press Ctrl+` or use Formulas > Show Formulas to confirm the sheet is not in formula view.
Inspect the cell format in the Home tab — Text format prevents calculation.
Make sure the formula starts with = and not a space before =.

Change format to General, press F2, then Enter.
Copy a working formula from another cell and adapt the references.
Use Find and Replace to clean accidental leading spaces in a column of formulas.

Ctrl+` shows formulas — how do I turn off? Press Ctrl+` again or Formulas → Show Formulas to return to calculated values.
Apostrophe before = in CSV imports? Remove leading apostrophe or use Text to Columns on General format, then re-enter the formula.
Formula works in one cell but not copied down? Downstream cells may be formatted as Text. Set the column to General and fill down again.

Problem: Excel displays formula text when the worksheet is in Show Formulas mode, the cell is formatted as Text, or the formula was entered with a leading space.
Quick fix: Turn off Show Formulas, set the cell to General format, delete any leading space before the equals sign, and re-enter the formula.
Reproduce on three sample rows before changing production formulas shared with the whole team.
Save version history or a copy before bulk find-replace across thousands of cells.
If the fix works on a sample but fails in production, compare text vs number storage on key columns.

IF (/functions/if/): =IF(logical_test, value_if_true, [value_if_false]) — Returns one value if a condition is TRUE and another value if it's FALSE.
SUM (/functions/sum/): =SUM(number1, [number2], ...) — Adds all the numbers in a range of cells.
VALUE (/functions/value/): =VALUE(text) — Converts a text string that represents a number to a number.

Rebuild the formula on a blank sheet with minimal ranges to isolate the failing argument.
Document the root cause in a shared runbook so the next teammate does not repeat the same fix.
Link to fix-excel-formula-errors (/guides/fix-excel-formula-errors/) when multiple error types appear.
Escalate to Power Query or IT when the source system export format changed without notice.