This short code example shows how to format a column as numeric in Excel
Columns(
"F:J"
).
Select
Selection.NumberFormat =
"#,##0.00"