#VALUE! error — what it means and how to fix it
#VALUE! is Excel's broadest error. It fires whenever a formula receives something it can't work with — the wrong kind of input for that operation. The fix is different depending on what triggered it, so the first job is figuring out which situation you're in.
Start here: find which situation you're in
Click on the cell showing the error and look at the formula bar to see the formula and which cells it uses. Then check those input cells against the three situations below — each one has its own fix, and matching yours tells you exactly what to do.
Situation 1: A cell contains text, but the formula is doing math
This is the most frequent cause. Formulas like =A2+B2 or =A2*1.1 only work when both cells contain real numbers. If one of them contains text — even something that looks like a number, like the word "150" — Excel can't add them and shows #VALUE!.
How to confirm it: Click the cell the formula is reading from. If it has a small green triangle in the corner, it's flagged as text. You can also type =ISNUMBER(A2) in an empty cell — if it returns FALSE, that cell holds text, not a number.
How to fix it: Select the column with the text-formatted numbers. Go to Data > Text to Columns and click Finish without changing any settings. Excel converts the text back to real numbers, and your formula should update immediately.
Situation 2: The data was pasted from a website or another program
Copy-pasting from a browser, a PDF, or another application often brings along hidden characters — spaces that aren't normal spaces, special line-break characters, or other invisible content that looks like nothing but breaks formulas. Your cell visually looks fine but contains extra stuff the formula can't handle.
How to confirm it: Click into the formula bar for the problem cell and use the arrow keys to move through it character by character. If the cursor stops in places that look empty, there are hidden characters there. Alternatively, check whether =LEN(A2) returns a higher number than you'd expect for the content.
How to fix it: Wrap the cell in =TRIM(CLEAN(A2)). TRIM removes extra spaces; CLEAN removes hidden non-printable characters. Do this in a helper column, then paste those results as values back over the original column.
Situation 3: Dates are stored as words instead of real dates
This is a subtler version of the same problem. When Excel stores a proper date, it's actually a number behind the scenes (January 1, 1900 was day 1; every day after is one higher). Formulas that subtract dates or calculate durations work because of this. But if a date was imported as text — "July 4, 2025" typed as words, or "04/07/2025" in a format Excel didn't recognize — it's stored as text and date math breaks with #VALUE!.
How to confirm it: Dates stored as real dates will show a number if you format the cell as a plain number (for example, 2026 would show as something in the 46000 range). Dates stored as text will just show the text string. You can also check with =ISNUMBER(A2).
How to fix it: Use =DATEVALUE(A2) to convert a text date into a real date number, then format the result cell as a date. Or select the date column and use Text to Columns — at step 3 of the wizard, choose Date and select the format your dates are in (MDY, DMY, YMD) before clicking Finish.
When none of these match
#VALUE! can also fire in more specific formulas — an array formula with mismatched range sizes, a text function receiving a number it can't parse, or a function used in a version of Excel that doesn't support it fully. If the three situations above don't describe your case, click the cell with the error and look at the specific function in the formula. The Microsoft support page for that function will list which inputs cause #VALUE! for it specifically.
The fix formula errors tool can scan your spreadsheet for columns with mixed types — cells that have a mix of real numbers and text-formatted numbers in the same column — and report exactly which rows have the problem, so you know where to focus.
Not sure which cells are triggering the error? Upload your file to the fix formula errors tool and get a plain-language report of where Excel sees the wrong input types.