Dates not sorting Properly in Excel

traversd · Mar 25th, 2002, 10:27 AM

Hi,
I have a colutmn of dates that are part of a table. The data is input via a form (Thanks to Audiojoe for the spinbutton code) and then sorted.

The problem seems to be that the dates are only sorted on the day part of the data (format is dd/mm/yyyy) Therefore the 16/04/2002 is coming before 25/03/2002.

This little nuance is wrecking my home made task / to-do list app !!

Any help greatly appreciated.

Regards
Darren

lenze · Mar 25th, 2002, 10:30 AM

It appears your dates are entered as text. You will need to convert them to numbers for Excle to sort them properly. Easiest way is to multiply each date by 1 and reformat. Place the number 1 in a empty cell, copy it, and then do a paste special Multiply on your date column.

[ This Message was edited by: lenze on 2002-03-25 09:32 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 10:27 AM	#1
traversd Board Regular Join Date: Mar 2002 Posts: 82	Hi, I have a colutmn of dates that are part of a table. The data is input via a form (Thanks to Audiojoe for the spinbutton code) and then sorted. The problem seems to be that the dates are only sorted on the day part of the data (format is dd/mm/yyyy) Therefore the 16/04/2002 is coming before 25/03/2002. This little nuance is wrecking my home made task / to-do list app !! Any help greatly appreciated. Regards Darren

Mar 25th, 2002, 10:30 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	It appears your dates are entered as text. You will need to convert them to numbers for Excle to sort them properly. Easiest way is to multiply each date by 1 and reformat. Place the number 1 in a empty cell, copy it, and then do a paste special Multiply on your date column. [ This Message was edited by: lenze on 2002-03-25 09:32 ]