TEXT function

Prev Next

​Description

Converts a Number or Integer to a Text.

Syntax

TEXT(Value to Convert)

Arguments

Argument

Type

Dimensions

Description

Value to Convert

(required)

Number or Integer

Any Dimensions

Value to convert to a Text.

Returns

Type

Dimensions

Text

Dimensions of Value to Convert

Examples

Formula

Result

Description

TEXT(32)

“32”

The Integer 32 is converted to its corresponding Text.

TEXT(-44.23)

“-44.23”

See also

Excel: TEXT

Related articles: VALUE

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!