PivotField.NumberFormat Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns or sets the format code for the object. Read/write String.

public:
 property System::String ^ NumberFormat { System::String ^ get(); void set(System::String ^ value); };

public string NumberFormat { get; set; }

Public Property NumberFormat As String

Property Value

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.

Applies to