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

@