Hey I'm sorting these dates from old to new in Excel.
All have date formats but the format is different.
<tbody>
</tbody>
All have date formats but the format is different.
21/11/2017 |
22/11/2017 |
24/11/2017 |
27/03/2018 |
19/04/2018 |
06/03/2018-07/03/2018 |
07/12/2017-08/12/2017 |
08/02/2018-09/02/2018 |
08/03/2018-09/03/2018 As you can see Excel is able to sort the dates in this format correct dd/mm/yyyy but in this format it goes wrong dd/mm/yyyy-dd/mm/yyyy (for example 07/12/2017 ) Bot formats are in the same column. Why is this and how can I sort it correctly? I'm using office 2010. Same problem in newer versions. Thank you. |
<tbody>
</tbody>
Last edited: