ID | Excel Format ID | Description |
---|---|---|
0 | 0 | No formating |
1 | 0 | No formating (align left) |
2 | 1 | 0 |
3 | 2 | 0.00 |
4 | 3 | #,## |
5 | 4 | #,##0.00 |
6 | 5 |
|
7 | 6 |
|
8 | 7 |
|
9 | 8 |
|
10 | 37 | #,##0_);(#,##0) |
11 | 38 | #,##0_);[Red](#,##0) |
12 | 39 | #,##0.00_;(#,##0.00) |
13 | 40 | #,##0.00_);[Red](#,##0.00) |
14 | 9 | 0% |
15 | 10 | 0.00% |
16 | 11 | 0.00E+00 |
17 | 48 | ##0.0E+0 |
18 | 14 | m/d/yyyy |
19 | 15 | d-mmm-yy |
20 | 16 | d-mmm |
21 | 17 | mmm-yy |
22 | 18 | h:mm AM/PM |
23 | 19 | h:mm:ss AM/PM |
24 | 45 | mm:ss |
25 | 46 | [h]:mm:ss |
26 | 47 | mm:ss.0 |