Dec 18 2014 11:50AM
Good morning, someone has sent me a spreadsheet with dates as above. I cannot re-format it as it appears to be an exported CSV file and all columns are set to General format. So I have the data but I cannot work with this format.
I was thinking along the lines of setting up an Import Spec in Access to extract parts of this date, but i have 3 date columns like this and would be very fiddly, is there a way in Excel to easily extract the correct dd/mm/yy hh:mm format.
Bookmarks