When importing dates and times from Excel we recommend formatting cells as Text. Follow this step by step guide:

First, select the cells that contain date and time data. Right click and select Format Cells...

In the Numbers tab, select Text from the Category list. Then click OK and you are ready to import.

Did this answer your question?