sort dates by dd/mm/yyyyy

[Guest]

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!

 

[Peo Sjoblom]

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

 

[Fred Smith]

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.

 

[Guest]

I was able to sort in the format that you mentioned by selecting the column
with the dates, click on data then text to columns. Choose fixed width to
keep your whole date in one cell. Click next until you get to where you can
Then click where you can format your data. Choose the date, click finish and
then do your sort.