Forum Discussion
Help with date sorting in order
Do you want to sort by the "Target Date" column? The dates in this column are left-aligned which means they are text. If dates which are text are sorted the result is not as intended.
Thank you for such a super speedy reply. This doc is stored in SharePoint and so I opened it in excel to see if that gave me more fexibility. When I look at "Format Cells" the cells are all in "Date" format. Do I need to change them to . separating the numbers rather than / as in your example? Or change to number format but surely that will sort by the first set of digits first all the way down so I could have 5th of one month followed by 6th of the next?
Even if the formatting is set to Date, Excel can still treat the values as Text.
Try the following:
- Select the target dates.
- On the Data tab of the ribbon, click Text to Columns.
- Click Finish.
- Are they now right-aligned? If so, select any one of them, then sort the range.
You shouldn't change / to .
The . is OliverScheurich 's data separator in his local language.
