#VALUE!Excel error guide No upload

#VALUE! in Excel — Wrong value type

#VALUE! means Excel expected a number, date or logical value but found text, an empty cell or a value from another data type. The fix is to convert the input, remove hidden characters, or guard the calculation with IFERROR.

Reviewed 31 October 2026 Tested in Excel 365; fixes apply to 2021, 2024 and Mac where the feature exists

The short answer

What it looks like

A formula that adds, subtracts or compares cells returns #VALUE!
The same formula works for some rows but fails for others
Dates or numbers look correct but are stored as text

Why #VALUE! happens

Text in a cell that the formula treats as a number, such as "12 kg" instead of 12.
A date imported from a CSV, PDF or website that Excel stored as text.
A non-printing character, leading apostrophe or double space in a numeric cell.
An array formula that returns different-sized arrays, or an operation on a whole column that includes text headers.
A function argument has the wrong type — for example, a text value where a number is required.

How to fix #VALUE!

1
Convert text numbers with VALUE or a number format
If the cell only looks like a number, VALUE converts it. For a whole column, use Text to Columns or multiply by 1 in a helper column, then paste the result back as values.
```
=VALUE(TRIM(A2))
```
2
Remove invisible characters
TRIM removes extra spaces and CLEAN removes non-printing characters. Combine them when data comes from a PDF or CRM export.
```
=VALUE(CLEAN(TRIM(A2)))
```
3
Guard the result with IFERROR
If a bad row should not stop the report, wrap the calculation. This hides the error but does not fix the source — use it only after you understand the cause.
```
=IFERROR(A2*B2,"")
```
4
Check the formula's argument types
Use the Evaluate Formula tool (Formulas → Evaluate Formula) to step through the calculation. The step that first shows #VALUE! is the argument to correct.

A safer formula pattern

=IFERROR(VALUE(TRIM(A2))*B2,"")

Converts a text number after trimming spaces, then hides the error if the cell cannot be converted.

Check it in your own workbook

Paste the formula into the free browser tools to see the exact fix without uploading your file. The Error Fixer explains the code, the Formula Checker finds syntax problems, and the Formula Explainer breaks down nested logic.

Open the interactive Error Fixer Check a formula

Related functions

VALUE TRIM CLEAN IFERROR DATEVALUE

Frequently asked questions

What does #VALUE! mean in Excel?

How do I fix #VALUE! in Excel?

Convert text numbers with VALUE or a number format: If the cell only looks like a number, VALUE converts it. For a whole column, use Text to Columns or multiply by 1 in a helper column, then paste the result back as values. Remove invisible characters: TRIM removes extra spaces and CLEAN removes non-printing characters. Combine them when data comes from a PDF or CRM export.

Why does #VALUE! appear only in some rows?

Usually because only some rows contain the trigger: Text in a cell that the formula treats as a number, such as "12 kg" instead of 12. A date imported from a CSV, PDF or website that Excel stored as text. A non-printing character, leading apostrophe or double space in a numeric cell.

How can I stop #VALUE! from appearing again?

Converts a text number after trimming spaces, then hides the error if the cell cannot be converted. Use this pattern as a guard: =IFERROR(VALUE(TRIM(A2))*B2,"")

Related Excel error guides

All error codes →

#REF!Broken cell reference#REF! means a formula points to a cell, row, column or sheet that no longer exists. It usually appears after deleting rows or columns, moving a sheet, or pasting a formula into a workbook that does not contain the referenced sheet.#N/ALookup value not found#N/A means a lookup or match function could not find the value. The value may be missing, spelled differently, stored as text instead of a number, or surrounded by spaces. Use exact-match mode and return a clear fallback.#DIV/0!Division by zero#DIV/0! appears when a formula divides by zero or by an empty cell. Excel treats a blank denominator as zero. Check the denominator, exclude blank rows, or return a controlled blank with IFERROR.#NAME?Unknown function or name#NAME? means Excel does not recognise a function, named range or reference in the formula. The usual causes are a misspelled function, missing quotation marks around text, or a function that is not available in your Excel version.

Still stuck?

Send the workbook and get the formula fixed

A human Excel expert can repair the formula, explain the cause and return a tested workbook — usually within 24 hours. Fixed quote before work starts, from $15/hr.

Get a fixed quote Ask on WhatsApp

#VALUE! in Excel — Wrong value type

Reviewed 31 October 2026 Tested in Excel 365; fixes apply to 2021, 2024 and Mac where the feature exists

Why #VALUE! happens

Text in a cell that the formula treats as a number, such as "12 kg" instead of 12.

A date imported from a CSV, PDF or website that Excel stored as text.

A non-printing character, leading apostrophe or double space in a numeric cell.

An array formula that returns different-sized arrays, or an operation on a whole column that includes text headers.

A function argument has the wrong type — for example, a text value where a number is required.

How to fix #VALUE!

Convert text numbers with VALUE or a number format

If the cell only looks like a number, VALUE converts it. For a whole column, use Text to Columns or multiply by 1 in a helper column, then paste the result back as values.

=VALUE(TRIM(A2))

Remove invisible characters

TRIM removes extra spaces and CLEAN removes non-printing characters. Combine them when data comes from a PDF or CRM export.

=VALUE(CLEAN(TRIM(A2)))

Guard the result with IFERROR

If a bad row should not stop the report, wrap the calculation. This hides the error but does not fix the source — use it only after you understand the cause.

=IFERROR(A2*B2,"")

Check the formula's argument types

Use the Evaluate Formula tool (Formulas → Evaluate Formula) to step through the calculation. The step that first shows #VALUE! is the argument to correct.