introduction excel training - date sorting

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » introduction excel training - Date Sorting

introduction excel training - Date Sorting

resolvedResolved · 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

RE: Date Sorting

Hi Anthony,

Thank you very much. I'm finding this and all the other responses very helpful.

Norah.

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Server loaded in 0.09 secs.