ABCDE
1
type123encoding (NB National decimal dividers can be different!)
2
Divider900.001,250.0013,749.00#,##0.00
3
Double Zero00011200
4
Even Thousand1.0001.00014.0000,".000"
5
No Decimal K0 K1 K2 K0, "K"
6
Decimal K0.387 K0.950 K1.800 K0.000, "K"
7
Decimal K Variant0.0 K250.0 K12,004.3 K#,##0.0, "K"
8
Million0.25 Mio.0.88 Mio.12.00 Mio.0.00,, "Mio."
9
EUR StringEUR 900.00EUR 1,250.00EUR 13,749.00"EUR" #,##0.00
10
EUR CurrencyEUR 900.00EUR 1,250.00EUR 13,749.00[$EUR] #,##0.00
11
€ Currency900.00 €1,250.00 €13,749.30 €#,##0.00[$ €]
12
$ Currency$900.00$1,250.00$13,749.30[$$]#,##0.00
13
Generic Currency¤ 900.00¤ 1,250.00¤ 13,749.30[$¤ ]#,##0.00
14
Accounting US $ 1,043,493.29 $ (338,432.17) $ - _("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)
15
Accounting DE 1,043,493.29 € - 338,432.17 € - € _-* #,##0.00\ [$€-1]_-;\-* #,##0.00\ [$€-1]_-;_-* "-"??\ [$€-1]_-;_-@
16
Finance1,043,493.29(338,432.17)0.00#,##0.00;(#,##0.00)
17
Filler~463.00~1.00~10,385.00*~#,##0.00
18
Long Number113 185 9215 698 196 6 528### ### ###
19
Leading Zero013 185 921005 698 196000 006 528000 000 000
20
KWKW_01KW_02KW_03"KW_"00
21
ISO Week Format2025-W482025-W502026-W480000"-W"00
22
ISO Weeday Format2025-W48-52025-W50-12026-W48-50000"-W"00"-"0
23
+/- %+ 117 %0 %- 31 %+ 0 %;- 0 %;0 %
24
Coloured +/-+ 10- 1[Color10]+ #;[Color3]- #;[Color15]0
25
Pale Zero10-1#;-#;[Color15]0
26
Dash Zero1-1#;-#;"–"
27
Number to BooleanTRUEFALSE---"TRUE";"---";"FALSE"
28
Ordinal Number1.2.3.#".";-#;#
29
DDD DD/MM/YYYYFri 28/11/2025Wed 14/01/2026Mon 17/11/2025DDD DD/MM/YYYY
30
YYYY-MM-DD2025-11-282025-12-182025-10-30YYYY-MM-DD
31
YYYY_MM_DD_hhmm2025_11_25_18292026_01_26_06572025_08_25_0542YYYY_MM_YY_hhmm
32
YYY-MM-DD hh:mm:ss2025-11-28 18:29:032026-02-12 22:33:512025-09-24 05:37:13YYYY-MM-DD hh:mm:ss
33
YYY-MM-DDThh:mm:ss2025-11-28T18:29:032026-01-25T20:38:392025-09-30T09:57:51YYYY-MM-DD"T"hh:mm:ss
34
hh:mm:ss.SSS18:29:03.00320:38:39.03909:57:51.051hh:mm:ss.SSS
35
AM/PM6:29 pm10:33 pm10:52 pmh:mm AM/PM
36
24 hours18:29:0302:09:514:45 amhh:mm:ss
37
above 24 hours56:25:560:35:530:12:02[h]:mm:ss
38
all minutes and seconds3385:5635:5312:02[m]:ss
39
all seconds2031562153722[s]
40
all seconds and miliseconds203156.0562153.053722.002[s].SSS
41
TIme Laps18h 29m22h 5m17h 17mh"h" m"m"
42
n/100117/1000/100 -31/100?/100; -?/100;0/100;
43
n/600 30/602 18/6011 5/60# ?/60
44
Decimal Hours0.50 dec h2.30 dec h11.08 dec h#,##0.00 "dec h"
45
Conditional Colour99100101[<100][Red]0;[>=100][Blue]0
46
Conditional Abbreviation6 Mio39 K872[>=1000000]0,, "Mio";[>=1000]0," K";0
47
Conditioned Texthighmidlow[>1000000]"high";[>10000]"mid";"low"
48
Text+84-41I wrote: something+0;-0;0;[color23]"I wrote: "@
49
Characte Wide Alignments$ 34.00 $(15.00)$ 0.00 "$"_(#,##0.00_);"$"(#,##0.00);"$"_(#,##0.00_)
50
Empty Space n-Width1 250 91513 749#_n##0
51
Empty Space m-Width1 250 91513 749#_m##0
52
Escape Character% 0.90% 0.15% 1.12\% 0.00
53
Lakh1,2341,23,4561234,56,789[>99999]##\,##\,##0;[<-99999.99]-##\,##\,##0;##,##0