Chris,

I figured out the macro idea, but it recommended something along the lines of:

wksht.Columns(6).Select
Selection.FormatNumber "m/d/yyyy"

When I brought that over to my code, I got an error (don't remember what it
was) that highlighted "Selection" when I went to debug it.

I tried:

wksht.Column(6).Select 'this worked
With Selection
.FormatNumber "m/d/yyyy"
end with

But that generated an error too; #91, "Object variable or With block
variable not set"

I really don't want to do this row by row, but will if I have to. I would
rather do it as I write the column headers.

Thanks for the idea.

Dale

"mcescher" wrote:

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.