| A | B | C | D | E | ||
|---|---|---|---|---|---|---|
1 | type | 1 | 2 | 3 | encoding (NB National decimal dividers can be different!) | |
2 | Divider | 900.00 | 1,250.00 | 13,749.00 | #,##0.00 | |
3 | Double Zero | 00 | 01 | 12 | 00 | |
4 | Even Thousand | 1.000 | 1.000 | 14.000 | 0,".000" | |
5 | No Decimal K | 0 K | 1 K | 2 K | 0, "K" | |
6 | Decimal K | 0.387 K | 0.950 K | 1.800 K | 0.000, "K" | |
7 | Decimal K Variant | 0.0 K | 250.0 K | 12,004.3 K | #,##0.0, "K" | |
8 | Million | 0.25 Mio. | 0.88 Mio. | 12.00 Mio. | 0.00,, "Mio." | |
9 | EUR String | EUR 900.00 | EUR 1,250.00 | EUR 13,749.00 | "EUR" #,##0.00 | |
10 | EUR Currency | EUR 900.00 | EUR 1,250.00 | EUR 13,749.00 | [$EUR] #,##0.00 | |
11 | € Currency | 900.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 | Finance | 1,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 Number | 113 185 921 | 5 698 196 | 6 528 | ### ### ### | |
19 | Leading Zero | 013 185 921 | 005 698 196 | 000 006 528 | 000 000 000 | |
20 | KW | KW_01 | KW_02 | KW_03 | "KW_"00 | |
21 | ISO Week Format | 2025-W48 | 2025-W50 | 2026-W48 | 0000"-W"00 | |
22 | ISO Weeday Format | 2025-W48-5 | 2025-W50-1 | 2026-W48-5 | 0000"-W"00"-"0 | |
23 | +/- % | + 117 % | 0 % | - 31 % | + 0 %;- 0 %;0 % | |
24 | Coloured +/- | + 1 | 0 | - 1 | [Color10]+ #;[Color3]- #;[Color15]0 | |
25 | Pale Zero | 1 | 0 | -1 | #;-#;[Color15]0 | |
26 | Dash Zero | 1 | – | -1 | #;-#;"–" | |
27 | Number to Boolean | TRUE | FALSE | --- | "TRUE";"---";"FALSE" | |
28 | Ordinal Number | 1. | 2. | 3. | #".";-#;# | |
29 | DDD DD/MM/YYYY | Fri 28/11/2025 | Wed 14/01/2026 | Mon 17/11/2025 | DDD DD/MM/YYYY | |
30 | YYYY-MM-DD | 2025-11-28 | 2025-12-18 | 2025-10-30 | YYYY-MM-DD | |
31 | YYYY_MM_DD_hhmm | 2025_11_25_1829 | 2026_01_26_0657 | 2025_08_25_0542 | YYYY_MM_YY_hhmm | |
32 | YYY-MM-DD hh:mm:ss | 2025-11-28 18:29:03 | 2026-02-12 22:33:51 | 2025-09-24 05:37:13 | YYYY-MM-DD hh:mm:ss | |
33 | YYY-MM-DDThh:mm:ss | 2025-11-28T18:29:03 | 2026-01-25T20:38:39 | 2025-09-30T09:57:51 | YYYY-MM-DD"T"hh:mm:ss | |
34 | hh:mm:ss.SSS | 18:29:03.003 | 20:38:39.039 | 09:57:51.051 | hh:mm:ss.SSS | |
35 | AM/PM | 6:29 pm | 10:33 pm | 10:52 pm | h:mm AM/PM | |
36 | 24 hours | 18:29:03 | 02:09:51 | 4:45 am | hh:mm:ss | |
37 | above 24 hours | 56:25:56 | 0:35:53 | 0:12:02 | [h]:mm:ss | |
38 | all minutes and seconds | 3385:56 | 35:53 | 12:02 | [m]:ss | |
39 | all seconds | 203156 | 2153 | 722 | [s] | |
40 | all seconds and miliseconds | 203156.056 | 2153.053 | 722.002 | [s].SSS | |
41 | TIme Laps | 18h 29m | 22h 5m | 17h 17m | h"h" m"m" | |
42 | n/100 | 117/100 | 0/100 | -31/100 | ?/100; -?/100;0/100; | |
43 | n/60 | 0 30/60 | 2 18/60 | 11 5/60 | # ?/60 | |
44 | Decimal Hours | 0.50 dec h | 2.30 dec h | 11.08 dec h | #,##0.00 "dec h" | |
45 | Conditional Colour | 99 | 100 | 101 | [<100][Red]0;[>=100][Blue]0 | |
46 | Conditional Abbreviation | 6 Mio | 39 K | 872 | [>=1000000]0,, "Mio";[>=1000]0," K";0 | |
47 | Conditioned Text | high | mid | low | [>1000000]"high";[>10000]"mid";"low" | |
48 | Text | +84 | -41 | I 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-Width | 1 250 | 915 | 13 749 | #_n##0 | |
51 | Empty Space m-Width | 1 250 | 915 | 13 749 | #_m##0 | |
52 | Escape Character | % 0.90 | % 0.15 | % 1.12 | \% 0.00 | |
53 | Lakh | 1,234 | 1,23,456 | 1234,56,789 | [>99999]##\,##\,##0;[<-99999.99]-##\,##\,##0;##,##0 |