Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sorting by date
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Sorting by date
Resolved · Urgent Priority · Version 2003
Reply Thu 19 Feb 2009, 15:01Delegate Liz said...
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?
For upcoming training course dates see: Pricing & availability
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
|