I have a set of data I'd like to manipulate- the only problem is that there are two date formats in the set. The formats are in this form:

Thursday 18th September 2013
Sat 15th Jun

The column format is set to general- I've tried to switch it to text or date via "format cells" but that doesn't change it. I've even tried multiplying the cells by 1 in a different column and converting to text but that doesn't work either

Is there a code for converting the date formats? Specifically to dd/mm/yyyy.