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

S

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.
 
N

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top