Excel 2007 : How to convert various date formats with time to dd-mmm-yy format?

Hi there,

I have a list of dates for the month of Sep that are of various formats such as :

09-09-10 0:00
09-09-10 0:00
09/13/10 12:00 AM
09/24/10 12:00 AM
09/24/10 12:00 AM

How can i convert them to the date format that I want without the time stamp? I have tried various functions etc but non really worked..

Please see attached example.
Any help would be greatly appreciated!