Description
The VALUE function converts a text value to a number, if possible.
Usage
VALUE(text)
| Argument | Type | Required | Description |
|---|---|---|---|
| text | Text | Yes | A textual value to convert to a number |
Result
- The numeric value of the text value.
- BLANK if the text value is not recognizable as a number.
Remarks
The VALUE function only recognizes Western Arabic numerals (1,2,3). Eastern Arabic numerals (١,٢,٣) or other numbers are not supported.
The VALUE functions interprets the period (.) as a decimal seperator and the comma (,) as a thousands seperator.
Examples
VALUE("365.0") == 365
VALUE(" 365") == 365
VALUE(1.25) == 1.25
ISBLANK(VALUE("١٢٣"))
VALUE("1.024E3") == 1024