Text

Syntax

Text(Value [, Format [, ResultLanguageTag]])

Parameters

Value

The number, date or other value to convert.

Formatoptional

A format string or a DateTimeFormat value.

ResultLanguageTagoptional

Language for the output, such as "en-US".

Examples

1. Text(Now(), "yyyy-mm-dd hh:mm")

   CopyCopied

   "2026-10-23 14:05"

2. Text(1234.5, "$#,##0.00")

   CopyCopied

   "$1,234.50"

3. Text(Today(), DateTimeFormat.LongDate)

   CopyCopied

   "Friday, October 23, 2026"