Pigment AI Agents are here! Starting today, we’re launching new AI Agents and updating our documentation for them. Some pages may look different or redirect to new resources. Send us feedback through "Was this article helpful?" at the foot of the page

VALUE function

  • Updated on Aug 22, 2025
  • 1 minute(s) read
Prev Next

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!

Related articles