I have this data in the below file.
They are dates.
Some are actual dates and some are not.
there are numbers shown behind the dates when I remove the formatting and I think this is the issue.
I am trying to import the data into Access and they will not import because they are not "real" dates. I guess this is the case.
The cells that are colored green in the attached are the ones that import correctly.
Let me know what the issue is.
I tried to do Text to Columns and selected Date but that is not the solution.
Please see attached.