Description
Converts a Text representing a number to a Number.
Syntax
VALUE(Text to Convert)
Note:
NUMBERis an alias to theVALUEfunction. It can be used this way:NUMBER(Text to Convert)
Arguments
Argument | Type | Dimensions | Description |
|---|---|---|---|
Text to Convert (required) | Text | Any Dimensions | Text to convert to a Number. |
Returns
Type | Dimensions |
|---|---|
Number | Dimensions of Text to Convert |
BLANK if Text to Convert is invalid or BLANK
Examples
Formula | Result | Description |
|---|---|---|
| 32 | |
| -44.23 | Negative and decimal numberes are converted. |
|
| “a” is not a valid number. |
|
|
See also
Excel: VALUE
Related articles: TEXT
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!