Enum NumberType

NumberType enumeration

Represents the number or datetime format type.

public enum NumberType

Values

NameValueDescription
General0General
Decimal11Decimal 0
Decimal22Decimal 0.00
Decimal33Decimal #,##0
Decimal44Decimal #,##0.00
Currency15Currency $#,##0;$-#,##0
Currency26Currency $#,##0;[Red]$-#,##0
Currency37Currency $#,##0.00;$-#,##0.00
Currency48Currency $#,##0.00;[Red]$-#,##0.00
Percentage19Percentage 0%
Percentage210Percentage 0.00%
Scientific111Scientific 0.00E+00
Fraction112Fraction # ?/?
Fraction213Fraction # ??/??
Date114Date m/d/yyyy
Date215Date d-mmm-yy
Date316Date d-mmm
Date417Date mmm-yy
Time118Time h:mm AM/PM
Time219Time h:mm:ss AM/PM
Time320Time h:mm
Time421Time h:mm:ss
Time522Time m/d/yy h:mm
Currency537Currency #,##0;-#,##0
Currency638Currency #,##0;[Red]-#,##0
Currency739Currency #,##0.00;-#,##0.00
Currency840Currency #,##0.00;[Red]-#,##0.00
Accounting141Accounting _ * #,##0_ ;_ * -#,##0_ ;_ * “-”_ ;_ @_
Accounting242Accounting _ $* #,##0_ ;_ $* -#,##0_ ;_ $* “-”_ ;_ @_
Accounting343Accounting _ * #,##0.00_ ;_ * -#,##0.00_ ;_ * “-”??_ ;_ @_
Accounting444Accounting _ $* #,##0.00_ ;_ $* -#,##0.00_ ;_ $* “-”??_ ;_ @_
Time645Time mm:ss
Time746Time [h]:mm:ss
Time847Time mm:ss.0
Scientific248Scientific ##0.0E+00
Text49Text @
Currency923Currency $#,##0;($#,##0)
Currency1024Currency $#,##0;Red
Currency1125Currency $#,##0.00;($#,##0.00)
Currency1226Currency $#,##0.00;Red
EasternDate127Date YYYY?M?
EasternDate228Date M?D?
EasternDate329Date M?D?
EasternDate430Date M/D/YY
EasternDate531Date YYYY?M?D?
EasternDate636Date YYYY?M?
EasternDate750Date YYYY?M?
EasternDate851Date M?D?
EasternDate952Date YYYY?M?
EasternDate1053Date M?D?
EasternDate1154Date M?D?
EasternDate1257Date YYYY?M?
EasternDate1358Date M?D?
EasternTime132Time h?mm?
EasternTime233Time h?mm?ss?
EasternTime334Time tth?mm?
EasternTime435Time tth?mm?ss?
EasternTime555Time tth?mm?
EasternTime656Time tth?mm?ss?

See Also