Just wondering if anyone knows a shortcut and/or formula to do this:
I have a file downloaded with around 11000 entries, The date and time is in US format i.e:
I need to convert this to UK format i.e.:
I have done a google search but can only find formulas to change cells with just the date.
Thanks a mill