 | FormatNumber Fields |
The StyleNumberFormatFormatNumber type exposes the following members.
Fields | Name | Description |
---|
  | custom | Custom Format (ID 164 and higher) |
  | format_1 | Format: 0 |
  | format_10 | Format: 0.00% |
  | format_11 | Format: 0.00E+00 |
  | format_12 | Format: # ?/? |
  | format_13 | Format: # ??/?? |
  | format_14 | Format: m/d/yyyy |
  | format_15 | Format: d-mmm-yy |
  | format_16 | Format: d-mmm |
  | format_17 | Format: mmm-yy |
  | format_18 | Format: mm AM/PM |
  | format_19 | Format: h:mm:ss AM/PM |
  | format_2 | Format: 0.00 |
  | format_20 | Format: h:mm |
  | format_21 | Format: h:mm:ss |
  | format_22 | Format: m/d/yyyy h:mm |
  | format_3 | Format: #,##0 |
  | format_37 | Format: #,##0_);(#,##0) |
  | format_38 | Format: #,##0_);[Red](#,##0) |
  | format_39 | Format: #,##0.00_);(#,##0.00) |
  | format_4 | Format: #,##0.00 |
  | format_40 | Format: #,##0.00_);[Red](#,##0.00) |
  | format_45 | Format: mm:ss |
  | format_46 | Format: [h]:mm:ss |
  | format_47 | Format: mm:ss.0 |
  | format_48 | Format: ##0.0E+0 |
  | format_49 | Format: # |
  | format_5 | Format: $#,##0_);($#,##0) |
  | format_6 | Format: $#,##0_);[Red]($#,##0) |
  | format_7 | Format: $#,##0.00_);($#,##0.00) |
  | format_8 | Format: $#,##0.00_);[Red]($#,##0.00) |
  | format_9 | Format: 0% |
  | none | No format / Default |
 | value__ | |
Top
See Also