Skip to main content

XlNumberFormat Members

Represents the object that specifies a cell number format.

Properties

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.

Methods

Name Description
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetType() Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString() Returns a string that represents the current object. Inherited from Object.
See Also