Excel Β· ChatGPT
Excel Showing Formula Instead of Result? Fix It
When Excel displays =SUM(...) in the cell instead of a number, the formula may be hidden by Show Formulas mode or stored as literal text. Match the visible symptom to one of three tested cases and restore the result without replacing formulas or source data.
Choose your situation β copy the prompt:
I am working in Quarterly Sales.xlsx on the worksheet Q1 Summary. The sheet contains: - B2: 1250 - B3: 980 - B4: 1420 - B5: =SUM(B2:B4) Instead of showing the expected total 3650, B5 displays =SUM(B2:B4). Other formula cells on the same worksheet also display their formulas instead of results: D2 contains =B2*10% and displays =B2*10%; D3 contains =B3*10% and displays =B3*10%. The formula bar shows the formulas normally. The affected cells are formatted as General, none begins with an apostrophe, calculation mode is Automatic, the formulas previously displayed results correctly, and I did not edit them individually. Explain the most likely cause, how to verify it, and the safe way to restore calculated results without deleting or re-entering any formulas. Account for differences between Excel for Windows and Excel for Mac, including the possibility that a keyboard shortcut may vary or conflict with the system keyboard layout. Confirm that B5 should display 3650 and that the formulas themselves should remain unchanged.
Use when several formula cells on the worksheet suddenly display formulas.
I am working in Product Pricing.xlsx on the worksheet Prices. The sheet contains: - B2: 24.50 - C2: 6 - D2 was formatted as Text before I entered the formula - I then typed =B2*C2 into D2 and pressed Enter D2 displays =B2*C2 instead of the expected result 147. Only D2 has this problem; formulas elsewhere display results normally. Show Formulas mode is off. Calculation mode is Automatic. The formula bar shows =B2*C2 with no leading apostrophe. B2 and C2 are numeric values, not text. Changing D2 from Text to General after the formula was entered does not immediately produce 147. Explain the cause and give safe, non-destructive steps that make Excel recognize the existing entry as a formula. Explain why changing the number format to General alone may not convert an entry that Excel already stored as text. Preserve B2, C2, and the formula =B2*C2, account for Windows and Mac editing differences, and confirm that the corrected result in D2 should be 147.
Use when one formula was entered into a cell that had already been formatted as Text.
I am working in Expense Report.xlsx on the worksheet Travel. The sheet contains: - B2: 185.75 - B3: 64.25 - B4: =SUM(B2:B3), which correctly displays 250 - B5 was entered as '=SUM(B2:B3) with a leading apostrophe B5 displays =SUM(B2:B3) instead of 250. B5 is formatted as General, not Text. Show Formulas mode is off. Calculation mode is Automatic. Other formulas, including the identical formula in B4, calculate normally. The leading apostrophe is visible when I edit B5 or inspect its entry in the formula bar, although Excel does not display that apostrophe in the worksheet cell. Explain why B5 is treated as literal text and give the safest way to remove only the leading apostrophe so Excel evaluates the entry as a formula. Do not change B2:B3, do not replace the formula with a fixed value, and do not use a bulk replacement that could alter unrelated cells. Account for Windows and Mac editing differences. Confirm that B5 should display 250 while retaining the formula =SUM(B2:B3).
Use when an apostrophe is visible before the equals sign while editing the cell.
Before β Show Formulas displays formula text
| Cell | Formula | Cell displays |
|---|---|---|
| B5 | =SUM(B2:B4) | =SUM(B2:B4) |
| D2 | =B2*10% | =B2*10% |
| D3 | =B3*10% | =B3*10% |
Quarterly Sales.xlsx Β· Q1 Summary Β· General format Β· Automatic calculation.
β
After β Show Formulas turned off
| Cell | Formula remains | Result |
|---|---|---|
| B5 | =SUM(B2:B4) | 3650 |
| D2 | =B2*10% | 125 |
| D3 | =B3*10% | 98 |
Formulas β Show Formulas changes display only; no formula needs re-entry.
Before β formula entered while D2 was Text
| Cell | Value / entry | Displayed |
|---|---|---|
| B2 | 24.50 | 24.50 |
| C2 | 6 | 6 |
| D2 | =B2*C2 | =B2*C2 |
| Format | Text before entry | |
Changing D2 to General alone does not reinterpret the existing stored text.
β
After β General, then edit and confirm
| Cell | Formula remains | Result |
|---|---|---|
| B2 | 24.50 | 24.50 |
| C2 | 6 | 6 |
| D2 | =B2*C2 | 147 |
| Action | Set General; edit D2; press Enter/Return | |
Reconfirming the existing entry makes Excel parse it as a formula without changing B2 or C2.
Before β apostrophe forces literal text
| Cell | Stored entry | Displayed |
|---|---|---|
| B2 | 185.75 | 185.75 |
| B3 | 64.25 | 64.25 |
| B4 | =SUM(B2:B3) | 250 |
| B5 | '=SUM(B2:B3) | =SUM(B2:B3) |
The apostrophe is hidden in the worksheet cell but visible while editing.
β
After β remove only the apostrophe
| Cell | Formula remains | Result |
|---|---|---|
| B2 | 185.75 | 185.75 |
| B3 | 64.25 | 64.25 |
| B4 | =SUM(B2:B3) | 250 |
| B5 | =SUM(B2:B3) | 250 |
Edit only B5, remove the leading apostrophe, and confirmβno bulk replacement.
Diagnose what Excel is displaying
Many formulas visible
Previously working formulas all appear in cells
Show Formulas
One Text-formatted cell
Formula was entered after format became Text
Reparse entry
Leading apostrophe
'=SUM(...) is visible while editing
Remove prefix
How to restore the calculated result safely
A practical four-step check
1
Check how many cells are affected
If many formulas display at once, inspect Formulas β Show Formulas. If only one cell is affected, inspect that cell's stored entry and format.
2
Turn off display mode when active
Use the ribbon command for reliable Windows and Mac behavior. Keyboard shortcuts may vary with Excel version and keyboard layout.
3
Reparse a Text-formatted entry
Change the affected cell to General, then edit and confirm the existing entry. On Windows use F2 then Enter; on Mac use the available edit command or the formula bar, then Return.
4
Remove only an intentional text prefix
If the entry begins with an apostrophe, remove only that character and confirm. Preserve the formula and source values.
Avoid bulk replacements. Do not replace formulas with fixed results or run Find and Replace across the workbook when only one literal-text entry is affected.
Frequently asked questions
Why is Excel showing a formula instead of the result?
The most common causes are Show Formulas mode being enabled, a formula entered while the cell was formatted as Text, or a leading apostrophe forcing the entry to remain literal text. Check whether all formulas or only one cell is affected before choosing a fix.
How do I turn off Show Formulas in Excel?
Open the Formulas tab and turn off Show Formulas. This restores calculated results without changing the formulas. Keyboard shortcuts vary by Excel version and keyboard layout, so the ribbon command is the most reliable method.
Why does changing a cell from Text to General not calculate the formula?
Changing the number format does not retroactively reinterpret text already stored in the cell. After changing the cell to General, edit and confirm the existing entry so Excel parses it as a formula.
Why does an apostrophe make Excel display my formula?
A leading apostrophe tells Excel to treat everything after it as literal text. Remove only that apostrophe from the affected cell and confirm the entry so Excel evaluates the formula.
Is this the same as an Excel formula not calculating?
No. This workflow covers cells that visibly display formula text. A cell showing an old or incorrect numeric result involves different causes such as calculation mode, external links, or circular references.