98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel ms training - Sorting dates
advanced excel ms training - Sorting dates
Resolved · Low Priority · Version Standard
Wed 3 Jan 2007, 12:00Delegate Kevin said...
Kevin has attended:
Word Advanced course
Excel Intermediate course
Sorting dates
I posted a question regarding filtering dates but it did not seem to work.
this is a sample of the list that we have and all we want to show is Januarys.
date
01/17/82
12/15/83
08/16/84
01/01/85
01/02/87
01/15/87
01/19/87
08/16/88
01/23/93
01/09/94
03/03/94
11/17/03
09/24/06
10/12/06
Either by filtering or sorting??
Wed 3 Jan 2007, 16:11Trainer Garry said...
RE: sorting dates
did you know the formats for these dates are different some are american date format and some are not dates but really text because they are left align which indicate these are text these may be the problem
did you import them from another program
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. |
Excel tip:Select Single Data MarkerTo select a single data marker in a chart, ie line, bar or column; |
