NumberType

NumberType enumeration

Represents the number or datetime format type.

public enum NumberType

Values

Name Value Description
General 0 General
Decimal1 1 Decimal 0
Decimal2 2 Decimal 0.00
Decimal3 3 Decimal #,##0
Decimal4 4 Decimal #,##0.00
Currency1 5 Currency $#,##0;$-#,##0
Currency2 6 Currency $#,##0;[Red]$-#,##0
Currency3 7 Currency $#,##0.00;$-#,##0.00
Currency4 8 Currency $#,##0.00;[Red]$-#,##0.00
Percentage1 9 Percentage 0%
Percentage2 10 Percentage 0.00%
Scientific1 11 Scientific 0.00E+00
Fraction1 12 Fraction # ?/?
Fraction2 13 Fraction # ??/??
Date1 14 Date m/d/yyyy
Date2 15 Date d-mmm-yy
Date3 16 Date d-mmm
Date4 17 Date mmm-yy
Time1 18 Time h:mm AM/PM
Time2 19 Time h:mm:ss AM/PM
Time3 20 Time h:mm
Time4 21 Time h:mm:ss
Time5 22 Time m/d/yy h:mm
Currency5 37 Currency #,##0;-#,##0
Currency6 38 Currency #,##0;[Red]-#,##0
Currency7 39 Currency #,##0.00;-#,##0.00
Currency8 40 Currency #,##0.00;[Red]-#,##0.00
Accounting1 41 Accounting _ * #,##0_ ;_ * -#,##0_ ;_ * “-”_ ;_ @_
Accounting2 42 Accounting _ $* #,##0_ ;_ $* -#,##0_ ;_ $* “-”_ ;_ @_
Accounting3 43 Accounting _ * #,##0.00_ ;_ * -#,##0.00_ ;_ * “-”??_ ;_ @_
Accounting4 44 Accounting _ $* #,##0.00_ ;_ $* -#,##0.00_ ;_ $* “-”??_ ;_ @_
Time6 45 Time mm:ss
Time7 46 Time [h]:mm:ss
Time8 47 Time mm:ss.0
Scientific2 48 Scientific ##0.0E+00
Text 49 Text @
Currency9 23 Currency $#,##0;($#,##0)
Currency10 24 Currency $#,##0;Red
Currency11 25 Currency $#,##0.00;($#,##0.00)
Currency12 26 Currency $#,##0.00;Red
EasternDate1 27 Date YYYY?M?
EasternDate2 28 Date M?D?
EasternDate3 29 Date M?D?
EasternDate4 30 Date M/D/YY
EasternDate5 31 Date YYYY?M?D?
EasternDate6 36 Date YYYY?M?
EasternDate7 50 Date YYYY?M?
EasternDate8 51 Date M?D?
EasternDate9 52 Date YYYY?M?
EasternDate10 53 Date M?D?
EasternDate11 54 Date M?D?
EasternDate12 57 Date YYYY?M?
EasternDate13 58 Date M?D?
EasternTime1 32 Time h?mm?
EasternTime2 33 Time h?mm?ss?
EasternTime3 34 Time tth?mm?
EasternTime4 35 Time tth?mm?ss?
EasternTime5 55 Time tth?mm?
EasternTime6 56 Time tth?mm?ss?

See Also