Hi Dale,

Cycle through the rows in your sheet
xlWks.Cells(intRow, 6).NumberFormat = "mm/dd/yyyy"

The quickest way to learn some of these things is to record a macro in
Excel, and then look at the code it creates. That's helped me MANY
times B-)

HTH,
Chris M.