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).
| 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.