PivotField.NumberFormat Property
Returns or sets the format code for the object. Read/write String.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property NumberFormat As String
Get
Set
'Usage
Dim instance As PivotField
Dim value As String
value = instance.NumberFormat
instance.NumberFormat = value
string NumberFormat { get; set; }
Property Value
Type: System.String
Remarks
For the PivotField object, you can set the NumberFormat property only for a data field.
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.