|Dates imported into Excel is one of the most common issues discussed in this forum.|
The problem is that the dates end up as text strings and Excel refuses to let go of that format.
What often works is to use the DATEVALUE function to force Excel to create a date serial number which can then be formatted as a date.
Dates and Times are store as "serial numbers" within Excel with the integer portion being the date and the decimal portion being the time.
1/1/1900 is Day 1, 9/15/2011 is Day 40801 (40,801 days since the beginning of Excel time)
The DATEVALUE function should return a 5 digit number which can then be formatted as a date. However, if there are spaces or hidden characters than came along when you did the import, you might have to use the TRIM or CLEAN functions to remove the extra characters so that DATEVALUE can work with the text string.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.