Summary

The Excel VALUE function converts text that represents a number into an actual numeric value. It is useful when imported data looks numeric on screen but Excel still treats it as text.

VALUE can convert plain numbers, currency strings, percentages, fractions, and time text if Excel recognizes the format. If the text cannot be interpreted as a number, VALUE returns #VALUE!.

Syntax

=VALUE(text)

Use text for the string or cell reference you want to convert. If spaces may be present around the value, a common pattern is =VALUE(TRIM(A1)).

Arguments

• text - [Required] The text string or cell reference that contains a numeric value stored as text.

VALUE vs Other Functions

VALUE is used when the problem is data type. The cell contains text, but you need a number. For the opposite direction, where you need to turn a number into formatted text, use TEXT instead.

Using VALUE

VALUE is most useful after importing data from CSV files, websites, ERP systems, or copied reports. These sources often produce numbers that look correct but are stored as text, which can break SUM, AVERAGE, lookups, and comparisons.

If the source column may contain mixed content, wrap VALUE in IFERROR. If stray spaces may be present, combine it with TRIM. Together, these patterns make batch conversion more reliable.

• Use VALUE when totals or lookups fail on cells that look numeric.
• Use VALUE(TRIM(A1)) if the imported text may include extra spaces.
• Use IFERROR when some rows may contain non-numeric text.

Example 1 - Converting a Text Number

This is the simplest case. VALUE removes the text type and returns a real number that math functions can use normally.

=VALUE("45")     // 45
=VALUE("3.14")   // 3.14
=VALUE(A1)       // Converts a text number stored in A1

Example 2 - Stripping Currency Formatting

VALUE can interpret common numeric formats such as a currency symbol and thousands separators. The result is still a number, not text, so it can be summed or compared normally.

=VALUE(B2)
// "$1,250" -> 1250
// "$45,000.00" -> 45000

Example 3 - Converting a Text Fraction

Fractions stored as text are not yet usable in calculation. VALUE converts them to their decimal equivalent, which makes them easier to use in arithmetic formulas.

=VALUE("1/2")   // 0.5
=VALUE("3/4")   // 0.75
=VALUE("5/2")   // 2.5

Example 4 - Checking the Conversion Result

Combining VALUE with ISNUMBER is a simple way to verify that the output is really numeric. If the text cannot be converted, VALUE returns an error, so IFERROR is often useful in mixed datasets.

=ISNUMBER(VALUE("500"))   // TRUE
=IFERROR(VALUE(A1), 0)    // Safe fallback if conversion fails

VALUE can also convert time text such as "12:00 PM" into Excel's underlying time serial. After conversion, format the result as time if you want it to display in time format again.

• VALUE returns #VALUE! when the text is not recognized as numeric.
• Use TRIM first if copied data may contain extra spaces.
• Use IFERROR when a column may contain both numeric and non-numeric text.

Conclusion Recap

• Summary: VALUE converts numeric text into a real number.
• Syntax: =VALUE(text).
• Best use: Fixing imported numbers that are stored as text.
• Common pattern: =IFERROR(VALUE(TRIM(A1)),0).
• Limitation: Non-numeric text returns #VALUE!.