NumberType

NumberType enumeration

Représente le type de format numérique ou datetime.

public enum NumberType

Valeurs

NomÉvaluerLa description
General0Général
Decimal11Décimal 0
Decimal22Décimal 0.00
Decimal33Décimal #,##0
Decimal44Décimal #,##0.00
Currency15Devise $#,##0;$-#,##0
Currency26Devise $#,##0;[Rouge]$-#,##0
Currency37Devise $#,##0.00;$-#,##0.00
Currency48Devise $#,##0.00 ;[Rouge]$-#,##0.00
Percentage19Pourcentage 0%
Percentage210Pourcentage 0,00%
Scientific111Scientifique 0.00E+00
Fraction112Fraction # ?/?
Fraction213Fraction # ??/??
Date114x000j Date m/j/aaaa_x000j_
Date215x000j Date j-mmm-aa_x000j_
Date316Date j-mmm
Date417x000j Date mmm-aa_x000j_
Time118Heure h:mm AM/PM
Time219Heure h:mm:ss AM/PM
Time320Heure h:mm
Time421Heure h:mm:ss
Time522x000j Heure m/j/aa h:mm_x000j_
Currency537Devise #,##0;-#,##0
Currency638Devise #,##0;[Rouge]-#,##0
Currency739Devise #,##0.00;-#,##0.00
Currency840Devise #,##0.00;[Rouge]-#,##0.00
Accounting141Comptabilité _ * #,##0_ ;_ * -#,##0_ ;_ * “-”_ ;_ @_
Accounting242Comptabilité _ $* #,##0_ ;_ $* -#,##0_ ;_ $* “-”_ ;_ @_
Accounting343Comptabilité _ * #,##0.00_ ;_ * -#,##0.00_ ;_ * “-”??_ ;_ @__
Accounting444Comptabilité _ $* #,##0.00_ ;_ $* -#,##0.00_ ;_ $* “-”??_ ;_ @_
Time645Heure mm:ss
Time746Temps [h]:mm:ss
Time847Heure mm:ss.0
Scientific248Scientifique ##0.0E+00
Text49Texte @
Currency923Devise $#,##0;($#,##0)
Currency1024Devise $#,##0;Rouge
Currency1125Devise $#,##0.00;($#,##0.00)
Currency1226Devise $#,##0.00 ;Rouge
EasternDate127Date AAAA?M?
EasternDate228Date M?D?
EasternDate329Date M?D?
EasternDate430x000j Date M/J/AA_x000j_
EasternDate531Date AAAA?M?J?
EasternDate636Date AAAA?M?
EasternDate750Date AAAA?M?
EasternDate851Date M?D?
EasternDate952Date AAAA?M?
EasternDate1053Date M?D?
EasternDate1154Date M?D?
EasternDate1257Date AAAA?M?
EasternDate1358Date M?D?
EasternTime132Heure h?mm?
EasternTime233Heure h?mm?ss?
EasternTime334Heure tth?mm?
EasternTime435Heure tth?mm?ss?
EasternTime555Heure tth?mm?
EasternTime656Heure tth?mm?ss?

Voir également