Excel Number Formats¶
The following integer values correspond to built-in Excel number formats.
While they cannot be used directly in python-pptx, this reference can be used to
determine the format strings that can be substituted in
ChartData.add_series()
to specify a numeric display format for series
values.
Further information on string number format codes (such as ‘#,##0’) can be found on this web page.
Value |
Type |
Format String |
0 |
General |
General |
1 |
Decimal |
0 |
2 |
Decimal |
0.00 |
3 |
Decimal |
#,##0 |
4 |
Decimal |
#,##0.00 |
5 |
Currency |
$#,##0;$-#,##0 |
6 |
Currency |
$#,##0;[Red]$-#,##0 |
7 |
Currency |
$#,##0.00;$-#,##0.00 |
8 |
Currency |
$#,##0.00;[Red]$-#,##0.00 |
9 |
Percentage |
0% |
10 |
Percentage |
0.00% |
11 |
Scientific |
0.00E+00 |
12 |
Fraction |
# ?/? |
13 |
Fraction |
# / |
14 |
Date |
m/d/yy |
15 |
Date |
d-mmm-yy |
16 |
Date |
d-mmm |
17 |
Date |
mmm-yy |
18 |
Time |
h:mm AM/PM |
19 |
Time |
h:mm:ss AM/PM |
20 |
Time |
h:mm |
21 |
Time |
h:mm:ss |
22 |
Time |
m/d/yy h:mm |
37 |
Currency |
#,##0;-#,##0 |
38 |
Currency |
#,##0;[Red]-#,##0 |
39 |
Currency |
#,##0.00;-#,##0.00 |
40 |
Currency |
#,##0.00;[Red]-#,##0.00 |
41 |
Accounting |
_ * #,##0_ ;_ * “_ ;_ @_ |
42 |
Accounting |
_ $* #,##0_ ;_ $* “_ ;_ @_ |
43 |
Accounting |
_ * #,##0.00_ ;_ * “??_ ;_ @_ |
44 |
Accounting |
_ $* #,##0.00_ ;_ $* “??_ ;_ @_ |
45 |
Time |
mm:ss |
46 |
Time |
h :mm:ss |
47 |
Time |
mm:ss.0 |
48 |
Scientific |
##0.0E+00 |
49 |
Text |
@ |