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
=Text(Now(), "yyyy-mm-dd hh:mm")"2026-10-23 14:05"
=Text(1234.5, "$#,##0.00")"$1,234.50"
=Text(Today(), DateTimeFormat.LongDate)"Friday, October 23, 2026"