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 | @ |