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:

Argument Description
value A value to convert to text.
format_text A 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