Description
Returns the specified text as a number.
Syntax
VALUE ( text )
| Parameter | Description |
|---|---|
| text | Any text string or a formula
that evaluates to a text string. You can also specify a date or time in a recognizable format (for example, M/DD/YY for dates or H:MM AM/PM for time). If the format is not recognized, #VALUE! is returned. |
Examples
This function returns 9800:
VALUE(9800)
This function returns 123:
VALUE("123")
See also