| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort date
Select the data.
DataText to ColumnsNextNextColumn Data FormatDMY and Finish. Gord Dibben MS Excel MVP On Sun, 29 Mar 2009 09:01:01 -0700, sksk4798 wrote: I have date range in Col A with the format say 24.01.2009 i.e.24th Jan 2009,20.03.2009, 19.02.2009,17.02.2009,16.03.2009 and so on. While I want to sort the dates in whole range according the ascending order, it is sorted like this: 24.01.2009 16.03.2009 17.02.2009 19.02.2009 20.03.2009 So the sorting is not done date wise. Any body can help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date sort | Excel Discussion (Misc queries) | |||
| the date format is not working ,sort by date doesn't work. | Excel Discussion (Misc queries) | |||
| Can't sort by date | New Users to Excel | |||
| Can't sort by date | New Users to Excel | |||
| Can't sort by date | New Users to Excel | |||
Hybrid Mode
