Home › Excel guides › #VALUE! and how localized decimals cause it

#VALUE! and how localized decimals cause it

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.

What #VALUE! is called in other languages

Like other error codes, #VALUE! is localized:

LanguageCode
English#VALUE!
German#WERT!
French#VALEUR!
Spanish#¡VALOR!
Russian#ЗНАЧ!

Why decimals cause #VALUE!

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)

How to fix it

  1. Find the text-numbers. Numbers stored as text are left-aligned and often show a green triangle. Real numbers are right-aligned.
  2. Replace the separator. Use Find & Replace to swap commas for points (or the reverse) in the affected column.
  3. Convert to number. Use Data → Text to Columns and finish, or multiply the column by 1, to force conversion.
  4. Prevent it on import. Use Data → From Text/CSV and set the correct locale so numbers parse correctly the first time.

Other causes of #VALUE!

See also decimal separators in Excel and the full error reference.

← All Excel guides

Copied to clipboard