Sorting data by date

K

Katherine

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
 
N

N Harkawat

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
 
P

Peo Sjoblom

You can use a help column

=--MID(4,2)

copy down and sort by the help column



--
Regards,

Peo Sjoblom

(No private emails please)
 
Top