VALUE
Description
VALUE returns the specified text as a number.
Syntax
VALUE ( text )
|
Parameter |
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:
VALUE(9800)
This function returns 123:
VALUE("123")
Also, see