This function converts a text string that is a number to a numeric value.
VALUE(text )
This function has these arguments:
| Argument | Description |
|---|---|
| text | Number in quotation marks or a reference to a cell with the text. |
The text can be in number, date, or time format. If the text is not in the correct format, a #VALUE! error is returned.
Accepts string data. Returns numeric data.
VALUE("$9,000")gives the result 9000
This function is available in product version 3.0 or later.
DOLLAR | DOLLARFR | FIXED | Text Functions