Description Returns the specified text as a number.
Syntax VALUE ( text )
| Argument | Description |
|---|---|
| text | Any text string, a formula that evaluates to a text string, or a cell reference that contains 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:
This function returns 123:
