Error ExplainerExcel #VALUE! error
A plain-words explanation of this Excel message: what it means, the usual causes, and the steps that fix it.
The message#VALUE!
Make the error yourself
Typed into Microsoft Excel 16.0 build 20326. This is the smallest example we could find that shows it.
| Cell | What was typed |
|---|---|
| A1 | ten |
| B1 | 5 |
| C1 | =A1+B1 |
The cell looked at: C1.
Excel shows: #VALUE!
Why it happens
The formula has the wrong type of value somewhere: Excel cannot add a word to a number. In the example A1 holds the word "ten". Other common reasons: a cell that looks empty but contains a space, numbers copied from another system that are stored as text with hidden characters, dates typed as text, a function that wants a single value but receives a range, and arrays that do not have matching sizes.
How to fix it
- Use Formulas > Evaluate Formula to find the part that fails, or check each cell used by the formula.
- Look for text where there should be numbers: text is left-aligned by default.
- Remove spaces and odd characters with
TRIMandCLEAN, orSUBSTITUTE(A1,CHAR(160),"")for the non-breaking space that often comes from web pages. - Convert text to numbers with
VALUE(A1), or multiply by 1. - Use functions that ignore text, such as
SUM(A1:B1)instead ofA1+B1.
The corrected version
| Cell | What was typed |
|---|---|
| A1 | 10 |
| B1 | 5 |
| C1 | =A1+B1 |
The cell looked at: C1.
Excel shows: 15
How to avoid it
Keep input cells as clean numbers (not text with units), and put units in a header.
Questions
Why does an empty-looking cell cause #VALUE!?
It probably contains a space or an invisible character. Select it and press Delete, or check with =LEN(A1).
This is an independent guide. It is not connected with Python, Microsoft, Google, GitHub or the Git project. Product names belong to their owners. Examples were run on 13 November 2026 in a practice folder or a blank workbook; your version may word a message slightly differently.