Share via

Excels ort function

Claire Greenwood - Enrich 0 Reputation points
2026-01-16T11:03:01.6933333+00:00

How can I sort by date using UK instead of US date formats? Eg: I will need 15.12.25 to sort so it shows on the list before 14.01.26

Microsoft 365 and Office | Excel | For education | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ppavle 5,295 Reputation points Volunteer Moderator
    2026-01-16T11:39:31.95+00:00

    Select cells with dates. Right click, Format Cells, select Date and choose English (United Kingdom) from the list.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.