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
8/5/2026
D
Wednesday, August 5, 2026
f
Wednesday, August 5, 2026 3:30 PM
F
Wednesday, August 5, 2026 3:30:37 PM
g
8/5/2026 3:30 PM
G
8/5/2026 3:30:37 PM
m
August 5
r
Wed, 05 Aug 2026 15:30:37 GMT
s
2026-08-05T15:30:37
t
3:30 PM
T
3:30:37 PM
u
2026-08-05 15:30:37Z
U
Wednesday, August 5, 2026 10:30:37 PM
y
August 2026
dddd, MMMM dd yyyy
Wednesday, August 05 2026
ddd, MMM d "'"yy
Wed, Aug 5 '26
dddd, MMMM dd
Wednesday, August 05
M/yy
8/26
dd-MM-yy
05-08-26
MM/yyyy
08/2026
MM\/dd\/yyyy HH:mm
08/05/2026 15:30
yyyyMMdd
20260805
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
