Date not formatted correctly

Hi,

I have a load of dates that copy from another sheet, which has been working fine, i now have some dates that left aligned as not a true date,

Columns are E and F for dates, ive tried cdate, datevalue, but cannot seem to get them correct. closest i have managed to get work is

Please Login or Register  to view this content.

but when i try to filter the dates are showing incorrect i.e months instead of days etc. looks like the true dates are correct but the others are not.

Just add pressing f2 and enter fixes the dates.

any ideas on how to resolve this ?

VBA only recognises the m/d/yyyy (US-style) date format. This causes similar issues all the time. You'd do well to attach a sampe workbook (desensitised).