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"