Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting dates in the format Jan Feb Mar Apr ... ???
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting dates in the format Jan Feb Mar Apr ... ???
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. Colin Gorman wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting dates in the format Jan Feb Mar Apr ... ???
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 "Colin Gorman" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting dates in the format Jan Feb Mar Apr ... ???
that did it many thanks
ul, 19:28, Dave Peterson wrote: 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. Colin Gorman wrote: 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 -- Dave Peterson- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting dates in the format Jan Feb Mar Apr ... ???
That worked great, thanks!
On 10 Jul, 19:32, FSt1 wrote: 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 "Colin Gorman" wrote: 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- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Dates | Excel Discussion (Misc queries) | |||
Sorting Dates | New Users to Excel | |||
Format text 'dates' to real dates | Excel Worksheet Functions | |||
Sorting Dates | Excel Worksheet Functions | |||
the dates on cell format make different dates. | New Users to Excel |