Click or drag to resize
PicoXLSX

FormatNumber Fields

The StyleNumberFormatFormatNumber type exposes the following members.

Fields
 NameDescription
Public fieldStatic membercustomCustom Format (ID 164 and higher)
Public fieldStatic memberformat_1Format: 0
Public fieldStatic memberformat_10Format: 0.00%
Public fieldStatic memberformat_11Format: 0.00E+00
Public fieldStatic memberformat_12Format: # ?/?
Public fieldStatic memberformat_13Format: # ??/??
Public fieldStatic memberformat_14Format: m/d/yyyy
Public fieldStatic memberformat_15Format: d-mmm-yy
Public fieldStatic memberformat_16Format: d-mmm
Public fieldStatic memberformat_17Format: mmm-yy
Public fieldStatic memberformat_18Format: mm AM/PM
Public fieldStatic memberformat_19Format: h:mm:ss AM/PM
Public fieldStatic memberformat_2Format: 0.00
Public fieldStatic memberformat_20Format: h:mm
Public fieldStatic memberformat_21Format: h:mm:ss
Public fieldStatic memberformat_22Format: m/d/yyyy h:mm
Public fieldStatic memberformat_3Format: #,##0
Public fieldStatic memberformat_37Format: #,##0_);(#,##0)
Public fieldStatic memberformat_38Format: #,##0_);[Red](#,##0)
Public fieldStatic memberformat_39Format: #,##0.00_);(#,##0.00)
Public fieldStatic memberformat_4Format: #,##0.00
Public fieldStatic memberformat_40Format: #,##0.00_);[Red](#,##0.00)
Public fieldStatic memberformat_45Format: mm:ss
Public fieldStatic memberformat_46Format: [h]:mm:ss
Public fieldStatic memberformat_47Format: mm:ss.0
Public fieldStatic memberformat_48Format: ##0.0E+0
Public fieldStatic memberformat_49Format: #
Public fieldStatic memberformat_5Format: $#,##0_);($#,##0)
Public fieldStatic memberformat_6Format: $#,##0_);[Red]($#,##0)
Public fieldStatic memberformat_7Format: $#,##0.00_);($#,##0.00)
Public fieldStatic memberformat_8Format: $#,##0.00_);[Red]($#,##0.00)
Public fieldStatic memberformat_9Format: 0%
Public fieldStatic membernoneNo format / Default
Public fieldvalue__ 
Top
See Also