Liz has attended:
SharePoint course
Sorting by date
I have a schedule with a column for dates.
I want to re-sort the items into date order.
Its not working for me.
I've tried it in 2 different files. In one the cells were predefined as DATE. In the other, the cells were originally defined as GENERAL but I have now changed the whole column to DATE.
Why is this not working please?
RE: sorting by date
Hi Liz
Thank you for your question. One thing you might want to try is to create a new blank workbook then create three dates in a column and test the sort feature (Data > Sort) to make sure you get the results you expect.
If that works then we know Excel is behaving as expected we just need to track down the problem in your work book. Click on one of the cells that contains a date. Press F2 on your keyboard and check the very beginning of the date value. Is there an apostrophe ' right at the start of the date? The apostrophe tells Excel to treat the contents of the cell as text even if you have applied a different format to the cell.
Let me know how you get on.
Kind regards,
Andrew
