XlNumberFormat Properties

Represents the object that specifies a cell number format.

Name	Description
DayMonth static	Gets the XlNumberFormat object that uses the "d-mmm" format code to display a cell value as a date.
FormatCode	Gets the format code corresponding to the current number format.
FormatId	Gets the unique identifier associated with the current number format.
Fraction static	Gets the XlNumberFormat object that uses the "# ?/?" format code to display a cell number as a fraction.
Fraction2 static	Gets the XlNumberFormat object that uses the "# ??/??" format code to display a cell number as a fraction.
General static	Gets the XlNumberFormat object that uses the General format to display numeric data in a cell.
IsDateTime	Gets a value indicating whether the current XlNumberFormat is a date and time format.
LongDate static	Gets the XlNumberFormat object that uses the "d-mmm-yy" format code to display a cell value as a date.
LongTime12 static	Gets the XlNumberFormat object that uses the "h:mm:ss AM/PM" format code to display a cell value as a time value.
LongTime24 static	Gets the XlNumberFormat object that uses the "h:mm:ss" format code to display a cell value as a time value.
MinuteSeconds static	Gets the XlNumberFormat object that uses the "mm:ss" format code to display a cell value as a time value.
MinuteSecondsMs static	Gets the XlNumberFormat object that uses the "mm:ss.0" format code to display a cell value as a time value.
MonthYear static	Gets the XlNumberFormat object that uses the "mmm-yy" format code to display a cell value as a date.
NegativeParentheses static	Gets the XlNumberFormat object that uses the "#,##0;(#,##0)" format code to display numeric data in a cell.
NegativeParentheses2 static	Gets the XlNumberFormat object that uses the "#,##0.00;(#,##0.00)" format code to display numeric data in a cell.
NegativeParenthesesRed static	Gets the XlNumberFormat object that uses the "#,##0;[Red](#,##0)" format code to display numeric data in a cell.
NegativeParenthesesRed2 static	Gets the XlNumberFormat object that uses the "#,##0.00;[Red](#,##0.00)" format code to display numeric data in a cell.
Number static	Gets the XlNumberFormat object that uses the "0" format code to display numeric data in a cell.
Number2 static	Gets the XlNumberFormat object that uses the "0.00" format code to display numeric data in a cell.
NumberWithThousandSeparator static	Gets the XlNumberFormat object that uses the "#,##0" format code to display numeric data in a cell.
NumberWithThousandSeparator2 static	Gets the XlNumberFormat object that uses the "#,##0.00" format code to display numeric data in a cell.
Percentage static	Gets the XlNumberFormat object that uses the "0%" format code to display a cell number as a percentage.
Percentage2 static	Gets the XlNumberFormat object that uses the "0.00%" format code to display a cell number as a percentage.
Scientific static	Gets the XlNumberFormat object that uses the "0.00E+00" format code to display numeric data in a cell.
Scientific1 static	Gets the XlNumberFormat object that uses the "##0.0E+0" format code to display numeric data in a cell.
ShortDate static	Gets the XlNumberFormat object that uses the "mm-dd-yy" format code to display a cell value as a date.
ShortDateTime static	Gets the XlNumberFormat object that uses the "m/d/yy h:mm" format code to display a cell value as a date and time.
ShortTime12 static	Gets the XlNumberFormat object that uses the "h:mm AM/PM" format code to display a cell value as a time value.
ShortTime24 static	Gets the XlNumberFormat object that uses the "h:mm" format code to display a cell value as a time value.
Span static	Gets the XlNumberFormat object that uses the "[h]:mm:ss" format code to display a cell value as the total amount of time elapsed.
Text static	Gets the XlNumberFormat object that uses the "@" character to display a cell value as a text.