Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
Fix the Text error
Excel & Google SheetsWhat Text means
When a cell is formatted as Text before you type a formula, the application stores the entry as a plain string rather than evaluating it. The formula appears exactly as typed — including the leading equals sign — and never computes a result.
Common causes
- The cell was formatted as 'Text' before the formula was entered, so the application ignores the leading '=' and stores the raw string.
- A leading apostrophe was accidentally typed before the '=' (e.g., '=SUM(A1:A10)), which forces text mode regardless of cell format.
- Manual Calculation is off and the cell was never recalculated, causing it to retain the formula string from a paste operation.
- The file was imported from CSV or a plain-text source that did not evaluate formulas on import.
- In Google Sheets, the column was formatted as Plain text via Format > Number > Plain text before data entry.
Example fix
Broken
=SUM(B2:B10)Fixed
=SUM(B2:B10)The formula text is identical — the fix is changing the cell format from Text to General and pressing Enter to force evaluation. The fixed version computes the sum; the broken version displays the literal string '=SUM(B2:B10)'.
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How to fix it
- 1Select the affected cell(s). In Excel: Home > Number group > change the format dropdown from 'Text' to 'General'. In Google Sheets: Format > Number > Automatic.
- 2After changing the format, re-enter the formula: press F2 to enter edit mode, then press Enter. Simply reformatting without re-entering does not recalculate.
- 3To fix many cells at once, change the range format to General/Automatic, then use Find & Replace (Ctrl+H) to replace '=' with '=' — this forces a re-evaluation of every formula in the selection.
- 4If a leading apostrophe is the cause, delete the cell contents, ensure the format is General, and retype the formula without the apostrophe.
- 5Check File > Options > Formulas (Excel) or Tools > Calculation settings (Sheets) and confirm calculation mode is Automatic, not Manual.
Stop hunting errors by hand.
Upload your spreadsheet and the Auditor flags every Text and broken formula at once — or paste this one formula and get the fix explained.
Frequently asked
Why does reformatting the cell not immediately show the result?
Changing the format only tells the cell how to display future entries. You must also re-enter the formula (press F2, then Enter) to trigger evaluation. Without this step the stored value remains a string.
Can I fix an entire column of formulas-as-text at once?
Yes. Select the column, change format to General, then open Find & Replace, search for '=' and replace with '=' with no other changes. This forces every formula in the selection to recalculate.
My formula only shows as text in one specific sheet — why?
That sheet's column was probably formatted as Text at some point (perhaps via a template or import). The format is stored per-cell, so only those cells are affected. Check the Number format in the ribbon for the affected cells.