Range.NumberFormat Property
Returns or sets the format code for the object.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property NumberFormat As Object
Get
Set
'Usage
Dim instance As Range
Dim value As Object
value = instance.NumberFormat
instance.NumberFormat = value
Object NumberFormat { get; set; }
Property Value
Type: System.Object
Remarks
This property returns Null if all cells in the specified range don't have the same number format.
The format code is the same string as the Format Codes option in the Format Cells dialog box. The Format function uses different format code strings than do the NumberFormat and NumberFormatLocal properties.