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!

sort dates by dd/mm/yyyyy
 

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" wrote in message
...
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!

sort dates by dd/mm/yyyyy
 

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" wrote in message
...
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!

sort dates by dd/mm/yyyyy
 

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.

"Summer_Girl" wrote:

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!