Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting dates in a worksheet
I have a worksheet where the first column contains invoice dates
I have entered dates as follows in the first column 25-01-08 05-05-07 22-11-07 19-07-06 25-12-07 I want the above rows sorted on ascending order of date(first year, month and date). I have formatted the first column as date set to french(france) 14-03-01. ANy solutions -- reply to my posts are welcome |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting dates in a worksheet
If they are Excel dates, then a sort will do that by default.
If you've got text (which would mean that the format doesn't change if you change the date format of the cells in the column), then you need to turn them to dates, which you may be able to do by Data/ Text to Columns. -- David Biddulph "NSNR" wrote in message ... I have a worksheet where the first column contains invoice dates I have entered dates as follows in the first column 25-01-08 05-05-07 22-11-07 19-07-06 25-12-07 I want the above rows sorted on ascending order of date(first year, month and date). I have formatted the first column as date set to french(france) 14-03-01. ANy solutions -- reply to my posts are welcome |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting dates in a worksheet
The following is the result after I sort in ascending order without header
12/2/07 11/11/2007 22-05-07 25-01-08 Actually the result should be althrough the entire row 12/2/07 22-05-07 11/11/2007 25-01-08 -- reply to my posts are welcome "David Biddulph" wrote: If they are Excel dates, then a sort will do that by default. If you've got text (which would mean that the format doesn't change if you change the date format of the cells in the column), then you need to turn them to dates, which you may be able to do by Data/ Text to Columns. -- David Biddulph "NSNR" wrote in message ... I have a worksheet where the first column contains invoice dates I have entered dates as follows in the first column 25-01-08 05-05-07 22-11-07 19-07-06 25-12-07 I want the above rows sorted on ascending order of date(first year, month and date). I have formatted the first column as date set to french(france) 14-03-01. ANy solutions -- reply to my posts are welcome |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting dates in a worksheet
Yes. A good demonstration of the problem and of its cause. Well done!
-- David Biddulph "NSNR" wrote in message ... The following is the result after I sort in ascending order without header 12/2/07 11/11/2007 22-05-07 25-01-08 Actually the result should be althrough the entire row 12/2/07 22-05-07 11/11/2007 25-01-08 -- reply to my posts are welcome "David Biddulph" wrote: If they are Excel dates, then a sort will do that by default. If you've got text (which would mean that the format doesn't change if you change the date format of the cells in the column), then you need to turn them to dates, which you may be able to do by Data/ Text to Columns. -- David Biddulph "NSNR" wrote in message ... I have a worksheet where the first column contains invoice dates I have entered dates as follows in the first column 25-01-08 05-05-07 22-11-07 19-07-06 25-12-07 I want the above rows sorted on ascending order of date(first year, month and date). I have formatted the first column as date set to french(france) 14-03-01. ANy solutions -- reply to my posts are welcome |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting dates | Excel Discussion (Misc queries) | |||
Sorting dates | Excel Worksheet Functions | |||
Sorting Dates | Excel Discussion (Misc queries) | |||
Sorting Dates | Excel Worksheet Functions | |||
sorting using dates | Excel Discussion (Misc queries) |