Excel formula showing as text instead of calculating
The cell is formatted as text. Select the cell, change the format to Number, and press Enter. Excel will now calculate the formula.
When a cell is formatted as text, Excel shows the formula instead of the result. Changing the format back to Number fixes it.
Risk: Low
⏱ 5 minutes
Beginner
⚡ Before you start
- ✓Right-click the cell and look at Format Cells
- ✓Make sure it's set to Text format
- ✓Make sure the formula starts with an apostrophe (Ctrl+`). That forces text
Fix-IT-Bot will walk you through each step, just tap, no typing needed.
Skip, I just want a technicianCommon mistakes to avoid
- Not realizing the cell is text-formatted
- Not pressing Enter after changing the format
Signs you need professional help
- If changing format doesn't fix it, contact Microsoft Support.
Book a technician
We can fix most issues remotely in 15 minutes. Book your weekend slot and we handle the rest.
Was this guide helpful?
Can't fix it yourself?
Most issues are resolved remotely in 15 minutes. Weekend appointments only, no parts, no in-home visit needed.
