Excel does not recognise dates that have been copied from other source.

I have copied a list of dates from another data source to excel spreadsheet - I am unable to use these dates in a formula. I have used the format tool, changed my region format to 'Match Windows disp...