Ok so I have dates that have been written in as

Wednesday, 3 May 2009 not in 03/03/2009 format. Is there anyway of getting excel to recognise this as a date. I have tried to format as a date. (I am trying to use Date FIlters)

Thanks in advance