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
9/16/2026
D
Wednesday, September 16, 2026
f
Wednesday, September 16, 2026 8:38 AM
F
Wednesday, September 16, 2026 8:38:45
AM
g
9/16/2026 8:38 AM
G
9/16/2026 8:38:45 AM
m
September 16
r
Wed, 16 Sep 2026 08:38:45 GMT
s
2026-09-16T08:38:45
t
8:38 AM
T
8:38:45 AM
u
2026-09-16 08:38:45Z
U
Wednesday, September 16, 2026 3:38:45
PM
y
September 2026
dddd, MMMM dd yyyy
Wednesday, September 16 2026
ddd, MMM d "'"yy
Wed, Sep 16 '26
dddd, MMMM dd
Wednesday, September 16
M/yy
9/26
dd-MM-yy
16-09-26
MM/yyyy
09/2026
MM\/dd\/yyyy HH:mm
09/16/2026 08:38
yyyyMMdd
20260916
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