You type a formula, press Enter and nothing useful happens. Either the cell shows the formula as text, or it shows an old result, or it returns zero, or it refuses to update when you change a number. These problems have a small number of causes, and each has a quick fix. This guide lists nine common reasons that an Excel formula is not calculating, shows how to recognize each one, and explains the fix step by step: calculation set to Manual, cells formatted as Text, a leading apostrophe or space, Show Formulas turned on, numbers stored as text, circular references, a missing equals sign, wrong regional separators, and external links that did not refresh. A short checklist at the end helps you find the cause in about a minute.
Updated November 2026
In this guide
- Fix 1: calculation mode is set to Manual
- Fix 2: the cell is formatted as Text
- Fix 3: Show Formulas is turned on
- Fix 4: a leading apostrophe or space
- Fix 5: numbers stored as text
- Fix 6: a circular reference
- Fix 7: the equals sign is missing
- Fix 8: wrong separators for your region
- Fix 9: external links and manual refresh
- Quick checklist to find the cause
- Use the Evaluate Formula tool
- Practice problems
- Common mistakes
Fix 1: calculation mode is set to Manual
If formulas do not update when you change a number, check the calculation mode. Go to Formulas, then Calculation Options. If Manual is selected, Excel recalculates only when you press F9. Choose Automatic. This setting belongs to the Excel session, not the file, so it can be changed by another workbook that you opened first. A sign of the problem is that the status bar shows the word Calculate at the bottom left. Press F9 to recalculate all open workbooks, or Shift+F9 to recalculate only the active sheet. If a large workbook is slow, someone may have set Manual on purpose, so ask before changing it.
Fix 2: the cell is formatted as Text
When a cell has the Text format, Excel treats anything you type, including a formula, as plain text. The cell shows =A1+B1 instead of the result. Select the cell, go to Home, and change the number format from Text to General. Then click in the formula bar and press Enter to re-enter the formula. Changing the format alone does not recalculate the cell, which is why many people think the fix did not work. To fix many cells, change the format first, and then use Data, Text to Columns, Finish, or press F2 and Enter on each cell. See our guide to converting text to numbers in Excel for the same method on values.
Fix 3: Show Formulas is turned on
If every formula on the sheet shows as text, including the ones that worked yesterday, Show Formulas may be on. Go to Formulas and look at the Show Formulas button in the Formula Auditing group. If it is highlighted, click it to turn it off. The keyboard shortcut is Ctrl and the grave accent key, which is above the Tab key on most keyboards. You may have pressed it by accident. A sign of this problem is that the columns look wider than usual, because the formulas are longer than the results.
Fix 4: a leading apostrophe or space
A formula that starts with an apostrophe or a space before the equals sign is treated as text. Click the cell and look at the formula bar. If you see an apostrophe at the start, delete it. If the formula was pasted from a website or a message, it may include hidden spaces or curly quotation marks. Retype the equals sign and any quotation marks by hand. In formulas, straight quotation marks are required, and curly ones, which look slightly curved, cause errors or text results. A formula such as =IF(A1="Yes",1,0) will not work if the quotation marks are the curly kind.
Fix 5: numbers stored as text
If a formula returns 0, or ignores some cells, the numbers may be stored as text. A SUM that returns 0 for a column of numbers is the classic sign. Numbers stored as text are left-aligned and often show a green triangle. Convert them with the warning icon, Text to Columns, or by multiplying by 1 with Paste Special, as explained in our text to number guide. Hidden spaces can also be the cause, and you can clean them with TRIM, as covered in our guide to removing spaces in Excel. After the conversion, the formula updates at once.
Fix 6: a circular reference
A circular reference happens when a formula refers to its own cell, directly or through other cells. For example, putting =SUM(A1:A10) in cell A10 includes the cell itself. Excel shows a warning, and the result may be 0. Go to Formulas, click the arrow next to Error Checking, and choose Circular References to see which cell is involved. Fix the formula so that the range does not include the cell with the formula, such as =SUM(A1:A9) in A10. The status bar also shows Circular References with a cell address when the problem exists in the active sheet.
Fix 7: the equals sign is missing
Every formula must start with an equals sign. If you type SUM(A1:A3) without it, Excel treats it as text. Some people start with a plus sign, which also works in Excel because it converts the plus to an equals sign. Check the first character. Also check that the function name is spelled correctly. A typo such as SUMM gives a #NAME? error, not text, but it is another reason why the result is not what you expect. Use the function suggestions that appear as you type to avoid spelling mistakes.
Fix 8: wrong separators for your region
In some regions, Excel expects semicolons between function arguments instead of commas, and a decimal comma instead of a decimal point. If you copy a formula from a website written for another region, it may return an error or an unexpected value. For example, =IF(A1>5,"Big","Small") may need to be written as =IF(A1>5;"Big";"Small") on a computer with European settings. Check the list separator in the Windows regional settings, or type the formula using your own separators. When you share templates with clients in other countries, mention this, or use formulas that are tested on their settings.
Fix 9: external links and manual refresh
If a formula refers to another workbook, it may show an old value until the link is updated. Go to Data, Edit Links, and click Update Values. If the source file has moved or was renamed, the link breaks and you will see a message when you open the file. Click Change Source to point to the new location. For formulas that depend on a query or a pivot table, use Data, Refresh All. If the source workbook is closed, Excel uses the last saved values, so open the source and recalculate. Keep source and report files in the same folder to reduce broken links.
Quick checklist to find the cause
Run through this order. First, press F9 to see whether the value changes. If it does, calculation was set to Manual. Second, click the cell and look at the formula bar. If the formula shows as text, check the cell format and the first character. Third, check whether other formulas on the sheet work. If none do, check Show Formulas. Fourth, look at the numbers the formula uses and check whether they are left-aligned. Fifth, check the status bar for Circular References. Sixth, check Formulas, Error Checking for a list of problems. This sequence solves most cases in about a minute.
Use the Evaluate Formula tool
If the formula calculates but returns the wrong value, use Formulas, Evaluate Formula. It steps through the calculation one part at a time, so you can see which part gives an unexpected result. Click Evaluate repeatedly and watch how the formula changes. This is very helpful for long nested formulas, such as those in our IF statements guide, or lookups that return the wrong match, as covered in our VLOOKUP troubleshooting guide. You can also select part of a formula in the formula bar and press F9 to see the value of that part. Press Escape afterward, so you do not replace the formula with the value.
Practice problems
Try to reproduce each problem on a new sheet. Problem 1: format a cell as Text and type =1+1. You will see the formula as text. Fix it by changing the format to General and pressing Enter again. Problem 2: set calculation to Manual, change a number and see that the total does not change until you press F9. Problem 3: type a number with an apostrophe in front and see that SUM ignores it. Problem 4: create a circular reference by summing a range that includes the formula cell, and use Error Checking to find it. Problem 5: turn on Show Formulas and then turn it off again. Practicing the problems makes the fixes automatic.
Common mistakes
The most common mistake is to change the format to General and expect the formula to calculate without re-entering it. Another is to forget that Manual calculation is saved with the session, so it can affect other files. A third is to copy formulas from web pages with curly quotation marks. A fourth is to ignore the green triangle warnings, which often point directly to the problem. A fifth is to fix the symptom in one cell and not check the whole column. When you find the cause, check the entire sheet, because the same problem usually affects several cells.
Frequently asked questions
Why is my Excel formula not calculating?
Common causes are Manual calculation mode, a cell formatted as Text, Show Formulas turned on, a leading apostrophe, or numbers stored as text.
Why does my formula show as text?
The cell is formatted as Text or the formula starts with an apostrophe or space. Change the format to General and re-enter it.
How do I make Excel recalculate?
Press F9, or set Formulas, Calculation Options to Automatic.
Why does my SUM return 0?
The numbers may be stored as text. Convert them to numbers.
What is a circular reference?
A formula that refers to its own cell, directly or indirectly.


