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 numbers from other writing systems 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