VBA - Setting Format Cells

Post date: May 18, 2011 7:56:34 AM

set to Text

Columns("A:G").NumberFormat = "@"

set to number with no decimal

Columns("A:G").NumberFormat = "0"

set to date

Columns("C:C").NumberFormat = "dd/mm/yyyy"