Sorting dates in the format Jan Feb Mar Apr ... ???


C

Colin Gorman

If I list months as Jan Feb Mar in a column and copy the sequence then
Apr May Jun Jul .... will appear. Not sure this is relevant to my
query below but shows me that excel recognises this date format.

However, if I have a list that is say;

Dec
Apr
Jun
Jan
Apr
Nov

I want it to sort so that the months and the rest of the row go in the
correct order by date, as below:

Jan
Apr
Apr
Jun
Nov
Dec

Instead, I can only get it to sort alpha order, as below:

Apr
Apr
Dec
Jan
Jun
Nov

Is there a way that I can get excel to sort my rows using the date
format I want in that one date column?

Any advice appreciated.
Colin
 
Ad

Advertisements

D

Dave Peterson

You can select your range and then do Data|Sort (xl2003 menus).

Specify your fields and click on the Options button.
You can change the sort order from Normal to a custom list (use the dropdown).

Then finish up.
 
F

FSt1

hi
yes, there is a way.
on the sort dailog box, set sort key one to the date column. then click the
options button at the lower left. from the drop down, select jan, feb, mar,
apr, etc.....
in xl that is custom option 4.
click ok, click ok.

Regards
FSt1
 
C

Colin Gorman

that did it many thanks


You can select your range and then do Data|Sort (xl2003 menus).

Specify your fields and click on the Options button.
You can change the sort order from Normal to a custom list (use the dropdown).

Then finish up.









--

Dave Peterson- Hide quoted text -

- Show quoted text -
 
Ad

Advertisements

C

Colin Gorman

That worked great, thanks!

hi
yes, there is a way.
on the sort dailog box, set  sort key one to the date column. then click the
options button at the lower left. from the drop down, select jan, feb, mar,
apr, etc.....
in xl that is custom option 4.
click ok, click ok.

Regards
FSt1







- Show quoted text -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top