NumberFormat Property
Applies To
DataLabel object, DataLabels collection object, PivotField object, Range object, Style object, TickLabels object.
Description
Returns or sets the format code for the object. Returns Null if all cells in the specified range don't have the same number format. Read/write Variant for the Range object, read/write String for all other objects.
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.
See Also
NumberFormatLinked property, NumberFormatLocal property.
Example
These examples set the number format for cell A17, row one, and column C (respectively) on Sheet1.
Worksheets("Sheet1").Range("A17").NumberFormat = "General"
Worksheets("Sheet1").Rows(1).NumberFormat = "hh:mm:ss"
Worksheets("Sheet1").Columns("C"). _
NumberFormat = "$#,##0.00_);[Red]($#,##0.00)"