String Description of Numeric Formats (Python)

If you are using a localized version of IBM® SPSS® Statistics, use the strings displayed in the Format list box on the Format Value tab (accessed from Format>Cell Properties in the pivot table editor).

Table 1. Specifications for numeric formats
String Example / Description
#.# 1234.567
#.#;#.##E-# 1234.567(scientific notation if the cell is not wide enough)
#,###.## 1,234.567
#.###,## 1.234,567
#.##E+## 1.23E+03
##.#% 56.7%
dd.mmm.yy 28-OCT-94
dd-mmm-yyyy 28-OCT-1994
mm/dd/yy 10/28/94
mm/dd/yyyy 10/28/1994
dd.mm.yy 28.10.94
dd.mm.yyyy 28.10.1994
yy/mm/dd 94/10/28
yyyy/mm/dd 1994/10/28
yyddd 94301 (Julian date)
yyyyddd 1994301 (Julian date)
q Q yy 4 Q 94
q Q yyyy 4 Q 1994
mmm yy OCT 94
mmm yyyy OCT 1994
ww WK yy 43 WK 94
ww WK yyyy 43 WK 1994
dd-mmm-yyyy hh:mm 28-OCT-1994 08:03
dd-mmm-yyyy hh:mm:ss 28-OCT-1994 08:03:00
yyyy-mm-dd hh:mm 1994-10-28 08:03
yyyy-mm-dd hh:mm:ss 1994-10-28 08:03:00
ddd.hh.mm 301 20:03
ddd.hh/mm.ss.## 301 20:03:00.04
Monday, Tuesday... Friday
January, February... October
mm:ss 03:00
hh:mm 08:03
hh:mm:ss.## 08:03:00.04
$#,###.## $1,234.56

You can create up to five custom currency display formats that can include special prefix and suffix characters and special treatment for negative values. The five custom currency format names are CCA, CCB, CCC, CCD, and CCE. The string can be used to specify the currency formats.