Date cells imported from Access database not showing time

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3158092%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EDate%20cells%20imported%20from%20Access%20database%20not%20showing%20time%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3158092%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EWhen%20I%20import%20data%20from%20MS%20Access%20report%20into%20Excel%2C%20date%20field%20does%20not%20display%20time%20part%20of%20the%20date%20even%20though%20the%20full%20date%20is%20imported%20in%20the%20cell.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20have%20to%20click%20in%20the%20cell%20to%20see%20the%20full%20display%20of%20the%20date.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3158092%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

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.

0 Replies