NumberFormat Property

  • Article

Returns or sets the number format for the specified object. Read/write Variant for the Range object; read/write String for all other objects in the Applies To list.

expression.NumberFormat

*expression   * Required. An expression that returns one of the objects in the Applies To list.

Remarks

You can define a number format by using the same format codes as Microsoft Excel. For information on number format codes, see the "Create or delete a custom number format" topic in Microsoft Excel Help.

Example

The following example sets the number format for the ranges A1:E10 and F1:F10 on the active worksheet.

Sub FormatCells()

   Spreadsheet1.ActiveSheet.Range("A1:E10").NumberFormat = "0.###"
   Spreadsheet1.ActiveSheet.Range("F1:F10").NumberFormat = "Currency"

End Sub

Applies to | ChAxis Object | ChDataLabels Object | PivotField Object | PivotMemberProperty Object | PivotTotal Object | Range Object