Please advise. (I attached a picture below)
This is an anomaly in Excel, and can be frustrating.
What you need to do is change the formatting of your cells to 'General' before brining in the date column. If a column is formatted previously to number, and a date field is brought in, it will take on the previous formatting option.
Remove the column, format the new column to general, then bring in the column again.
Formatting of cells does not change the formatting for a date issue is generally encountered in these two cases:
Recently I have solved this issue when one of my friends caught into this trouble. My friend has gone through with the second case. For the fixes I have taken help from this post:
4 Quick & Easy Methods To Solve The “Date Format Not Changing In Excel”
Choose a location