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