Hi there,
Trying to sort via a date column from a inventory download.
Dates are being recognized as numbers in excel and therefore won't allow me to sort by oldest to newest.
In cell A1 I have: 12/18/2015 18:02
Is there a way to convert this number sequence into a usable excel date format that looks the same?
I tried using DATE, LEFT, RIGHT and MID functions but can't seem to make it work!
Also, other threads I found related to this process are slightly different!
Many thanks!!
Bookmarks