sorting dates

  • Thread starter Thread starter Tom Rogers
  • Start date Start date
T

Tom Rogers

I have a list of dates (in a column of cells) in the form
16/07/2003, 20/07/2003, 08/08/2003. When I try to sort by
date, the dates are in the order of the day only, not
month then dates ie 08/08/2003, 16/07/2003, 20/07/2003.
How can I get around this so that the date are in the
correct order?
Thanks
Tom
 
Sounds like they are text, not true dates, which are numbers. Assuming your Windows regional
settings are dd/mm/yyyy, convert to dates this way:

- Edit/Copy a blank cell
- Select the column of dates
- Edit/Paste Special and select the Values and Add options
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro help 1
date sort 4
How to select the date? 4
Difference in time 7
Date Difference 2
Sorting Date Column 1
Combining 2 kinds of graphs [how?] 2
Date format/value different when opening manually compare to VBA macro 4

Back
Top