98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » introduction excel training - Date Sorting
introduction excel training - Date Sorting
Resolved · Low Priority · Version Standard
Norah has attended:
PowerPoint Introduction course
Date Sorting
Hi,
Is is possible to have a date column just reading the month, and sorting as the month, rather than in alphabetical.
I understand that you can have date in a number of standard options (eg 01/01/07 , 01 January 07 etc) but is there a way where you simply just view the month in text (eg January , March), but it recognises it as a date rather than text.
Many thanks,
Norah.
RE: Date Sorting
Hi Norah. Yes, this is possible - in Excel. Use the Sort dialog box as usual but click on Options at the bottom left hand corner and make sure your "First Key Options" are set to the months of the year. This then becomes the default sort order.
Hope this helps,
Anthony
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. |