+ 0 Votes Answering date format question. jhicks22309 3 years ago If those cells are displaying "values" then you already have a date format (m/d/yyyy h:mm) that can be sorted. You can highlite the three columns and change the format to a different date format if you prefer a short format. If the cells actually contain "text" then your sort won't give you what you're looking for. In that case you'll need to convert the text to a value with something like =DATEVALUE(A1) and then format that as your prefered date format.