TEXT

Description

The TEXT function converts a value to text.

Usage

TEXT(value, format)
Argument Type Required Description
value text
number
boolean
time
date
month
week
single select
multiple select
Yes Value to convert
format text No Description of the format

The accepted format string depends on the type of the value.

Formatting numbers

If the value argument is a number, then the format string should be composed of the following symbols:

Symbol Meaning
0 Digit
# Digit, zero shows as absent
. Decimal separator
- Minus sign
, Grouping separator
% Multiply by 100 and show as percentage
Multiply by 1000 and show as per mille value
' Used to quote special characters in a prefix or suffix

Distinct formats for positive and negative numbers can be provided by separating two formatting strings with the semicolon character (;).

The following table provides examples for formatting numbers:

Value Format Result
12345 0,000 12,345
12345 0 12345
12345 #,### 12,345
345 #,### 345
2025 0000 2025
45 0 45
45 000 045
45 000.000 045.000
0.25 0% 25%
0.25 0.0% 25.0%
0.123456 ‰123.46 ‰123.46
35 0;(0) 35
-35 0;(0) (35)

The result reflects the current locale of the user. If you add a Calculated field with the TEXT(1025.33, “#,###.00”) Formula, then a user who configured ActivityInfo in English sees “1,025.33” but a user with French locale sees “1 025,33”.

For more information, see the Quantity field article.

Formatting dates and times

If the value argument is a date or a time, the following symbols are recognized in the format string:

Letter Date or Time Component Examples
yyyy or yy Year 2025 or 25
YYYY or YY Week year 2025 or 25
M, MM, MMMor MMMM Month of year 7, 07, Jul or July
d or dd Day in month 6 or 06
E or EE Day of week name Tue or Tuesday
a AM/PM marker PM
H or HH Hour in day (0-23) 7 or 07
h or hh Hour in am/pm (1-12) 2 or 02
m or mm Minute in hour (0-59) 5 or 05
s or ss Second in minute (0-59) 5 or 05
S Millisecond 978
z General timezone UTC+1
X ISO 8601 timezone -08

The following table shows examples of different formatting possibilities for the same date and time: 2025-01-16 14:30:33.

Format argument Result
yyyy-MM-dd 2025-01-16
d/m/yyyy 16/1/2025
dd/MM/yyyy 16/01/2025
d MMM yy 16 Jan 25
d MMMM yy 16 January 25
EEE d MMM yyyy Thu 16 Jan 2025
EEEE d Thursday 16
yyyy-MM-dd hh:mm a 2025-01-16 2:30 PM
yyyy-MM-dd HH:mm 2025-01-16 14:30
yyyy-MM-dd HH:mm:ss 2025-01-16 14:30:33

The result reflects the current locale of the user. If you add a Calculated field with the TEXT(DATE(2025, 1, 16), "MMMM d") Formula, then a user who configured ActivityInfo in English sees “January 16” but a user with French locale sees “janvier 16”.

For more information, see the Quantity field article.

Next item
QUARTER