Excel formulas stop calculating when you type them as text instead of a formula, or when the cell is formatted as text
The most common reason a formula does not calculate is that you forgot the equals sign at the start. Excel only recognizes a formula when it begins with =. If you type +A1+B1 or SUM(A1:A10) without the equals sign first, Excel treats it as plain text and displays exactly what you typed instead of the result.
The second most common reason is that the cell itself is formatted as text. When a cell is formatted as text, Excel will not calculate anything you put in it — it displays the formula as text instead of running it. This happens most often when you copy data from another program, or when you format a column as text before filling it with formulas.
A third reason is that automatic calculation is turned off. By default, Excel recalculates all formulas whenever you change a number. If you turned off automatic calculation (usually by accident), your formulas sit unchanged even when the numbers they depend on change.
Key Takeaways
- Every formula must start with an equals sign; =A1+B1 calculates, but A1+B1 displays as text.
- If a cell is formatted as text, Excel will not calculate anything in it, even if you type a correct formula.
- Automatic calculation can be turned off in the Formulas tab under Calculation Options, and turning it back on forces Excel to recalculate everything.
- Circular references — when a formula refers to its own cell — cause Excel to show an error or zero instead of calculating.
- Spaces or hidden characters in cell references can break a formula even when the syntax looks correct.
Check that the formula starts with an equals sign
Click the cell that is not calculating. Look at the formula bar at the top of the screen — the long white box that shows what is in the cell. If the formula bar shows your formula starting with a letter or number instead of =, that is the problem.
Delete the content and type it again, this time starting with =. For example, type =A1+B1 instead of A1+B1. Press Enter. The cell should now show the result instead of the text.
If you have many cells with this problem, you can fix them all at once. Select all the cells that need fixing, then use Find & Replace (Ctrl+H on Windows, Cmd+H on Mac). In the Find box, type the formula without the equals sign. In the Replace box, type the same formula with the equals sign. Click Replace All.
Change the cell format from text to a number format
Click the cell that is not calculating. Right-click and choose Format Cells (or press Ctrl+1 on Windows, Cmd+1 on Mac). The Format Cells dialog opens.
Look at the Category list on the left. If it says Text, click on Number or General instead. Click OK. Now go back to the cell, press F2 to edit it, and then press Enter. Excel will now calculate the formula.
If you have a whole column formatted as text, select the entire column by clicking the column letter at the top. Right-click, choose Format Cells, change the category to General or Number, and click OK. Then click on the first cell in that column, press F2, and press Enter. Excel will recalculate that cell. You can then copy the formula down to the rest of the column.
Turn automatic calculation back on
Go to the Formulas tab at the top of the screen. Look for a button called Calculation Options (it may show a small dropdown arrow). Click it and make sure Automatic is selected. If it shows Manual, click Automatic.
When you switch back to Automatic, Excel will recalculate all formulas in the spreadsheet. This can take a few seconds if your file is large. You will see the results update in front of you.
Automatic calculation is the default setting, so you should rarely need to do this. But if you or someone else opened the file with Manual calculation turned on, this is the fix.
Look for circular references
A circular reference happens when a formula refers to its own cell. For example, if cell A1 contains the formula =A1+5, that is circular — the formula is trying to use its own result to calculate itself. Excel cannot do this and will show an error or a zero instead.
To find circular references, go to the Formulas tab and click Error Checking (or the dropdown next to it). If there are circular references, Excel will list them and show you which cells are involved. Click on each one and check the formula. Usually you meant to refer to a different cell — for example, =A2+5 instead of =A1+5.
If you have a circular reference on purpose (some advanced spreadsheets use them with iteration turned on), you can ignore this. But in most cases, a circular reference is a mistake.
Check for spaces and hidden characters in cell references
Sometimes a formula looks correct but does not calculate because there is a space or hidden character in a cell reference. This is hard to spot by eye. Click the cell that is not calculating and look at the formula bar. The formula might look like =A1 +B1 (with a space before the plus sign) or =A1+B 1 (with a space in the cell reference).
Delete the formula and type it again carefully, or use the mouse to click on the cells you want to reference instead of typing their names. When you click on a cell, Excel types the reference for you, and you avoid typos and hidden characters.
If you copied the formula from another program like a web page or a PDF, spaces and special characters often come along. Paste it into a plain text editor first (like Notepad on Windows or TextEdit on Mac), copy it from there, and then paste it into Excel. This strips out hidden formatting.
Make sure the cells you are referencing contain numbers, not text
A formula can look correct and still not calculate if the cells it refers to contain numbers stored as text. For example, if cell A1 contains the number 5 but it is stored as text, a formula like =A1+B1 may not work or may show an error.
Click on a cell that the formula refers to. Look at the formula bar to see what it contains. If it is a number that looks like text (sometimes it appears left-aligned instead of right-aligned), it may be stored as text. Right-click the cell, choose Format Cells, change the format to Number, and click OK. Then press F2 and Enter to recalculate.
If you have a column of numbers stored as text, select the entire column. Go to the Data tab and look for Text to Columns. Click it, then click Finish without changing any settings. Excel will convert all the text numbers to real numbers in one step.
Frequently Asked Questions
Why does my formula show the formula itself instead of the answer?
The cell is probably formatted as text, or the formula does not start with an equals sign. Check the formula bar at the top — if you see the formula there but the cell displays it as text, right-click the cell, choose Format Cells, and change the category from Text to General or Number. Then press F2 and Enter.
I turned on automatic calculation but my formulas still are not updating when I change numbers
Make sure the cells you are changing actually contain numbers, not text. Also check that the formula is using the correct cell references — if the formula refers to a different cell than the one you are changing, it will not update. Click the formula cell and look at the formula bar to see which cells it references.
What does a circular reference error mean?
A circular reference means a formula is trying to use its own cell in the calculation. For example, =A1+5 in cell A1 is circular. Check the formula and change it to refer to a different cell, like =A2+5. Excel will tell you which cells have circular references if you go to Formulas > Error Checking.
Can I fix all my formulas at once if they are missing the equals sign?
Yes. Select all the cells with the problem, then use Find & Replace (Ctrl+H). In Find, type the formula without the equals sign. In Replace, type it with the equals sign. Click Replace All. Excel will fix them all in one step.
Why does my formula work in one cell but not when I copy it down?
When you copy a formula down, Excel changes the cell references automatically — =A1+B1 becomes =A2+B2 in the next row. If the formula stops working, check that the references are updating correctly. Click a cell in the copied formula and look at the formula bar. If the references are wrong, you may need to use absolute references like =$A$1+$B$1 instead.