I am using a new system which lets you export data into Pivot Tables, but the problems is the date comes out as text like this... Wednesday, May 14, 2014

How can I quickly convert this to a proper date, ie. DD/MM/YYYY?