Skip to main content

TEXT function

The TEXT function is one of the text and data functions. Is used to convert a value to a text in the specified format.

Syntax​

TEXT(value, format_text)

The TEXT function has the following arguments:

ArgumentDescription
valueA value to convert to text.
format_textA format to display the results in.

Notes​

How to apply the TEXT function.

Examples​

The figure below displays the result returned by the TEXT function.

TEXT Function