sorting dates

[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

 

[Myrna Larson]

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