excel courses in london - Converting dates

I have a range of dates that I have exported into Excel from another system. I need to compare these dates with another to get a period of time.

However, Excel is reading the exported dates as text, not as dates. I have tried doing Format - Cells etc. which has no effect. Can anyone think of a way to convert these to dates or even just to numbers?

Thanks

Tristan