How to format the date properly when exporting?

Hi all,

When I'm exporting our list of open SR's the date columns are coming down in the text format of:

Apr 5, 2016 9:56 AM

The problem with exporting a date like this is that it can't be converted by formatting the cell and it can't be split using text to columns either, as MMM, D, YYYY H:MM .. isn't an accepted format outside of text.

Anyone know how I can export it as DD/MM/YYYY? Or move time into a seperate column altogether?

Thanks,

Josh