## Purpose

## Return value

## Syntax

`=VALUE(text)`

*text*- The text value to convert to a number.

## How to use

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.

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

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.

- Use the VALUE function to convert text input to a numeric value.
- The VALUE function converts text that appears in a recognized format (i.e. a number, date, or time format) into a numeric value.
- Normally, Excel automatically converts text to numeric values as needed, so the VALUE function is not needed.
- The VALUE function is provided for compatibility with other spreadsheet programs.
- The VALUE function returns #VALUE! when a conversion is unsuccessful.