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
 
Back
Top