Dates in Excel are not sorting correctly

C

cleongatl

Am I losing my mind????

I have Office 2003, have been using Excel for YEARS, and certainly know my
way around the application.

I am having this issue where dates copied from Access into Excel are not
sorting correctly. I have tried to change the cell formats for the entire
column as well as changing the cell formats prior to copying the cells, and
it is just screwy. This is the second time in as many weeks that I have
experienced this. The dates in Access are of Short Date datatype,so I see no
reason why Excel should have any issue interpreting the values.

Is this a bug?? Is it Excel? or Access?

If anyone has some direction or inspiration, I'd surely appreciate hearing
it....
 

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

Top