
Converts a numeric value in a text field to a number format.
Syntax
VALUE(x)
where:
- x: numerical value in text-formatted field
Format
Input Format | Output Format |
---|---|
x: Text |
Number |
Arguments
The function uses the following arguments:
- x: text (value as numerals)
Constraints
The function has the following constraints:
- Text-format numeric value must be digits not words.
- No other formatting, such as "$","£","%", is accepted - full points are recognized.
- Negative values '-123' are translated to a negative value (-123).
Excel equivalent
Example
Text-formatted cellmyval | Number-formatted cell |
---|---|
1234 | VALUE(myval) = 1234 |
1,234 | VALUE(myval) = NaN |
$1234 | VALUE(myval) = NaN |
one | VALUE(myval) = NaN |