Date & time formats issue

Hi chaps,

I've attached a small sample of an excel file I created from a CSV. The date has defaulted to American format and the time is, as you can see, messy. How can I reformat so that I can have British date format and 24 hour clock?

try inserting a new column e
then data text to columns choose delimited ,choose space as delimiter
click next select the first column in the preview and then click the date button choose mdy from the dropdown
click finish