string
FormatProperties
.
TextFormat
Numeric/date format (e.g. MM-DD-YYYY).
This string overrides other formatting settings to create a custom format for a value. Usually
used with dates.
Example 1
Example
=
FormatTable
(
FormatValue
(
DateTime
.
Now
,
each
DateFormatExamples
));
//============================================================
Format String
Output
d
10/28/2026
D
Wednesday, October 28, 2026
f
Wednesday, October 28, 2026 3:43 PM
F
Wednesday, October 28, 2026 3:43:34 PM
g
10/28/2026 3:43 PM
G
10/28/2026 3:43:34 PM
m
October 28
r
Wed, 28 Oct 2026 15:43:34 GMT
s
2026-10-28T15:43:34
t
3:43 PM
T
3:43:34 PM
u
2026-10-28 15:43:34Z
U
Wednesday, October 28, 2026 10:43:34 PM
y
October 2026
dddd, MMMM dd yyyy
Wednesday, October 28 2026
ddd, MMM d "'"yy
Wed, Oct 28 '26
dddd, MMMM dd
Wednesday, October 28
M/yy
10/26
dd-MM-yy
28-10-26
MM/yyyy
10/2026
MM\/dd\/yyyy HH:mm
10/28/2026 15:43
yyyyMMdd
20261028
Example 2
Example2
=
FormatTable
(
FormatValue
(12345,
each
IntFormatExamples
));
//============================================================
Format String
Output
B
11000000111001
X
3039
0000000
0012345
#,###
12,345
Example 3
Example3
=
FormatTable
(
FormatValue
(12345.678,
each
DoubleFormatExamples
));
//============================================================
Format String
Output
C
$12,345.68
CE
CE
E2
1.23E+004
e2
1.23e+004
#.###
12345.678
#,###
12,346
#,###.##
12,345.68