Date cells imported from Access database not showing time

[James_za]

When I import data from MS Access report into Excel, date field does not display time part of the date even though the full date is imported in the cell.

I have to click in the cell to see the full display of the date.