G'day Keith

I'm assuming your importing as PasteSpecial.Value. Which means it pastes the
actual Time.Value, which in this case is 36892.

Highlight the entire column in question.
Goto: FormatCell | Number | Custom
Enter: mm-dd-yy

or if you prefer dd-mm-yy

HTH
Mark.