Excel Formulas Not Calculating and Showing as Text — Complete Fix
When Excel formulas do not calculate, the most common causes are Text format, Show Formulas mode, and Manual calculation. Check the following in order to resolve the issue within a minute.
Quick Fix (1 Minute)
- Select the range → Ctrl+1 → set the number format to General → press F2→Enter in each cell.
- Press Ctrl+` to turn off Show Formulas.
- Go to Formulas tab > Calculation Options > Automatic, then press F9 to recalculate.
Causes and How They Work
- Text format/leading apostrophe → Stored as a text string.
- Show Formulas mode → Formula strings appear throughout the sheet.
- Manual calculation → Values do not update after changes.
- Locale/separators → Differences between comma and semicolon argument separators.
- Circular references/spill blockers → Prevent results from being generated.
Fixes by Situation
Convert Text to Formulas in Bulk
Use Data > Text to Columns (Finish), or use Ctrl+H to remove apostrophes and then recalculate.
Calculation Mode/Recalculation
Switch to Automatic, then use F9/Shift+F9.
Correct the Locale
Adjust the formula for your comma or semicolon environment.
Circular References/Spill
Go to Formulas > Error Checking > Circular References to find and resolve the location, and remove anything blocking the spill range.
Practical Examples
// Turn off Show Formulas
Ctrl + `
// Force a full recalculation
Ctrl + Alt + F9
// Comma locale example
=SUM(A1,A10)
// Semicolon locale example
=SUM(A1;A10)
Troubleshooting
| Symptom | Cause | Solution |
|---|---|---|
| The =formula appears as-is | Text format/leading ‘ | Set the number format to General, then use Text to Columns (Finish) |
| Formulas appear across the entire sheet | Show Formulas mode | Turn it off with Ctrl+` |
| Values do not change | Manual calculation | Set Calculation Options to Automatic, then press F9 |
| Function error | Separator/locale | Check whether commas or semicolons are required |
| Result is 0/repeats | Circular reference | Use Error Checking to find and correct the location |
| #SPILL!/no result | Spill range blocked | Unmerge cells and remove blocking values |