sort dates by dd/mm/yyyyy

Does anyone know how to sort dates my dd/mm/yyyy?
I have checked my regional settings and they co-ordinate, but it keeps
sorting by day regardless of the month.
Any suggestions would help!

Make sure they are numerical, excel sort dates default by year/month/day, if
you want to sort by month/year and day you need to use a help column to
extract the months

=MONTH(A2)

copy down and select both columns and sort by the help column first, if you
get an error the dates are text


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Summer_Girl" <Summer_Girl@discussions.microsoft.com> wrote in message
news:45E6EFC3-6C89-458A-B9D4-D1B534EDABFE@microsoft.com...
> Does anyone know how to sort dates my dd/mm/yyyy?
> I have checked my regional settings and they co-ordinate, but it keeps
> sorting by day regardless of the month.
> Any suggestions would help!

Excel will always sort dates properly. However, you must have true Excel dates
in order for it to work. It sounds like you have text, rather than dates. Try
this:

-- put zero in a cell somewhere
-- copy it
-- highlight your range of dates
-- right click, choose Paste Special...>Add

This will turn your text into dates. You may have to format the cells to get
them to display dd/mm/yyyy.

Now the column will sort properly.

--
Regards,
Fred


"Summer_Girl" <Summer_Girl@discussions.microsoft.com> wrote in message
news:45E6EFC3-6C89-458A-B9D4-D1B534EDABFE@microsoft.com...
> Does anyone know how to sort dates my dd/mm/yyyy?
> I have checked my regional settings and they co-ordinate, but it keeps
> sorting by day regardless of the month.
> Any suggestions would help!