Excel 2003 seems to sort column of date, some by month & some by y

[sunny]

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.

 

[Niek Otten]

Probably the section sorted on mm was not recognized as dates and sorted as
text. Maybe your input was in dd/mm/yyyy format, on a machine wuth US
settings. Then 13/01/2001, meaning Jan 13 2001, but will not be recognized
as date because of the "month" 13.

You can find out with the ISTEXT() function.

 

[Gord Dibben]

Sounds like some dates are text, not real dates.

Select your column of dates and Data>Text to Columns>Next>Next>Column Data
Format>Date>MDY and Finish.


Gord Dibben MS Excel MVP