Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

NumberFormat Property [Excel 2003 VBA Language Reference]

Office 2003

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

expression.NumberFormat

expression Required. An expression that returns one of the above objects.

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.

expression.NumberFormat

expression Required. An expression that returns one of the above 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.

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)"
		




Show: