TEXT

The TEXT function allows you to format numbers, dates, times, and logical values by applying a specific display format, making the values more readable.

Use

TEXT( value [, display_format] )
Formats a value and converts it to text.

Parameter	Required	Description
value	Yes	a number, logical, date, time, or date/time value to format
display_format	No	a display format relevant to the data type (uses default if omitted)

Returns

Text

Example

This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.