NumberFormat Property Example

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

Spreadsheet1.ActiveSheet.Range("a1:e10").NumberFormat = "0.###"
Spreadsheet1.ActiveSheet.Range("f1:f10").NumberFormat = "Currency"