VBA - Setting the Data Format for a Column

Post date: May 18, 2011 7:51:32 AM

Sheet1.Range("E2", "E1000").NumberFormat = "m/d/yyyy hh:mm"

OR

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