NumberType

NumberType enumeration

Representerar formattypen för tal eller datum och tid.

public enum NumberType

Värderingar

namnVärdeBeskrivning
General0Allmänt
Decimal11Decimal 0
Decimal22Decimal 0,00
Decimal33Decimal #,##0
Decimal44Decimal #,##0.00
Currency15Valuta $#,##0;$-#,##0
Currency26Valuta $#,##0;[Röd]$-#,##0
Currency37Valuta $#,##0.00;$-#,##0.00
Currency48Valuta $#,##0.00;[Red]$-#,##0.00
Percentage19Procent 0%
Percentage210Procent 0,00%
Scientific111Scientific 0.00E+00
Fraction112Bråk # ?/?
Fraction213Bråk # ??/??
Date114Datum m/d/åååå
Date215Datum d-mmm-åå
Date316Datum d-mmm
Date417Datum mmm-yy
Time118Tid h:mm AM/PM
Time219Tid h:mm:ss AM/PM
Time320Tid h:mm
Time421Tid h:mm:ss
Time522Tid m/d/åå h:mm
Currency537Valuta #,##0;-#,##0
Currency638Valuta #,##0;[Röd]-#,##0
Currency739Valuta #,##0.00;-#,##0.00
Currency840Valuta #,##0.00;[Röd]-#,##0.00
Accounting141Redovisning _ * #,##0_ ;_ * -#,##0_ ;_ * “-”_ ;_ @_
Accounting242Redovisning _ $* #,##0_ ;_ $* -#,##0_ ;_ $* “-”_ ;_ @_
Accounting343Redovisning _ * #,##0.00_ ;_ * -#,##0.00_ ;_ * “-”??_ ;_ @_
Accounting444Redovisning _ $* #,##0.00_ ;_ $* -#,##0.00_ ;_ $* “-”??_ ;_ @_
Time645Tid mm:ss
Time746Tid [h]:mm:ss
Time847Tid mm:ss.0
Scientific248Vetenskaplig ##0.0E+00
Text49Text @
Currency923Valuta $#,##0;($#,##0)
Currency1024Valuta $#,##0;Röd
Currency1125Valuta $#,##0.00;($#,##0.00)
Currency1226Valuta $#,##0.00;Röd
EasternDate127Datum ÅÅÅÅ?M?
EasternDate228Datum M?D?
EasternDate329Datum M?D?
EasternDate430Datum M/D/YY
EasternDate531Datum ÅÅÅÅ?M?D?
EasternDate636Datum ÅÅÅÅ?M?
EasternDate750Datum ÅÅÅÅ?M?
EasternDate851Datum M?D?
EasternDate952Datum ÅÅÅÅ?M?
EasternDate1053Datum M?D?
EasternDate1154Datum M?D?
EasternDate1257Datum ÅÅÅÅ?M?
EasternDate1358Datum M?D?
EasternTime132Tid h?mm?
EasternTime233Tid h?mm?ss?
EasternTime334Tid tth?mm?
EasternTime435Tid tth?mm?ss?
EasternTime555Tid tth?mm?
EasternTime656Tid tth?mm?ss?

Se även