Share via

Excel - How to sort rows by date?

Anonymous
2023-05-26T11:08:35+00:00

Hello,

I wrote several dates on the lines.

Even though I set the cell formatting to date, it's still possible to sort A - Z, which it does by numbers, which logically doesn't work for date.

How do I do that, please?

Thank you

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2023-05-26T11:40:57+00:00

    Data>Text to Columns> Next,Next > choose date and select MDY or DMY to convert your data to date formta. Then you can sort it.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rory Archibald 18,875 Reputation points Volunteer Moderator
    2023-05-26T11:13:52+00:00

    Those dates are actually stored as text. Do you normally use the dot as the date separator in your regional settings?

    0 comments