Sounds like some dates are text, not real dates.

Select your column of dates and DataText to ColumnsNextNextColumn Data
FormatDateMDY and Finish.


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 12:43:01 -0700, sunny
wrote:

Hi,

I inherited an Access 2003 database where I reformatted all the date to
mm/dd/yyyy. I then copied it to Excel 2003 and sorted by date. For some
strange reason, I ended up with 2 sections, 1 sorted by the mm and the other
by the yyyy. I reformatted the column by date but it still has the same
problem.

Can anyone please help me with this? Thank you.