Description
Converts a Text representing a number to a Number.
Syntax
VALUE(Text to Convert)
Note: NUMBER is an alias to the VALUE function. 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 |
|---|---|---|
VALUE(“32”) | 32 | |
VALUE(“-44.23”) | -44.23 | Negative and decimal numberes are converted. |
VALUE(“a”) | BLANK | “a” is not a valid number. |
VALUE(‘MyList’.Name) | 
| MyList is a List containing: 
|
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!
