Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting data by date
I want to sort a list of dates into month order? At present the data is in
dd.mm.yy format. Using the sort function will only sort by day. Is there any way to sort the data by the month? Any help appreciated. The data has been exported from another system and is in text format at present. Thanks Katherine |
#2
|
|||
|
|||
You need to first convert it to a date from existing Text and can easily be
done as follows: Select the column of date(text format) Then on your menu go to Data--Text to columns.. Next Next Now select Date and dmy format Finish Now your text dates are actual dates and excel will sort it the way you want it "Katherine" wrote in message ... I want to sort a list of dates into month order? At present the data is in dd.mm.yy format. Using the sort function will only sort by day. Is there any way to sort the data by the month? Any help appreciated. The data has been exported from another system and is in text format at present. Thanks Katherine |
#3
|
|||
|
|||
You can use a help column
=--MID(4,2) copy down and sort by the help column -- Regards, Peo Sjoblom (No private emails please) "Katherine" wrote in message ... I want to sort a list of dates into month order? At present the data is in dd.mm.yy format. Using the sort function will only sort by day. Is there any way to sort the data by the month? Any help appreciated. The data has been exported from another system and is in text format at present. Thanks Katherine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data in linked worksheets | Excel Discussion (Misc queries) | |||
Help! Selecting data according to date range | Excel Discussion (Misc queries) | |||
Sorting by date when the date isn't exact | Excel Discussion (Misc queries) | |||
unwanted number to date conversion while pasting data from web | Excel Worksheet Functions | |||
Help with data not getting plotted | Charts and Charting in Excel |