How a decimal comma vs point mismatch produces #VALUE! errors, and how to clean numbers so formulas work.
The #VALUE! error means a formula received the wrong type of value — most often text where a number was expected. When files move between countries, a very common trigger is a mismatch in the decimal separator, which quietly turns numbers into text.
Like other error codes, #VALUE! is localized:
| Language | Code |
|---|---|
| English | #VALUE! |
| German | #WERT! |
| French | #VALEUR! |
| Spanish | #¡VALOR! |
| Russian | #ЗНАЧ! |
In comma-decimal regions, "one and a half" is written 1,5. If such a value is imported into an Excel that expects a decimal point, Excel can't read it as a number — it stores it as text. Any arithmetic on that text then returns #VALUE!:
="1,5" + 2 → #VALUE! (because "1,5" is text, not the number 1.5)
See also decimal separators in Excel and the full error reference.