ID EN
…
#Text

VALUE

Excel Functions

Convert text to a number

Syntax

EXCEL 
=VALUE(text)

Arguments

Parameter Description
text The text value to convert to a number.

Return Value

A numeric value.

Details

The VALUE function is meant to convert a text value that represents a number into a numeric value. The text can be a date, a time, or any other number, so long as the format can be recognized by Excel. When the conversion is successful, the result is a numeric value with no number formatting. When the VALUE function is unable to convert a text value to a numeric result, the result is a #VALUE! error. In general, there is no need to use the VALUE function because Excel automatically converts text to numbers as needed. However, VALUE is provided for compatibility with other spreadsheet applications.

Examples

Example 1

The VALUE function is meant to convert a text value that represents a number into a numeric value. The text can be a date, a time, or any other number

EXCEL 
=VALUE("July 15, 2021") // returns 44392
=VALUE("$125.50") // returns 125.5
=VALUE("32.5%") // returns 0.325

See Also

N DATEVALUE TIMEVALUE NUMBERVALUE VALUETOTEXT