Problem with sorting by date columns

D

Dupatt

I have had a problem with sorting by dates and sometimes with numbers after
pasting files from MS Access 2003 into Excel 2003. I use Access to query
out files that I need to analyze, then I analyze them in Excel.
I have had instances when some of the files will not sort ascending or
descending even after I have formatted the dates in the entire column and
have reformatted all of the other columns; it is like they don't format with
the others. I usually have about 12 to 15 columns, some text some numbers
and some dates. Can anyone explain how this happens? Am I doing something
wrong? Thanks, Pat
 

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

Calculate the median value before a specified list 0
Sorting a column based on required order 2
Sort The Date at the center of string with VBA 1
Sorting with expanding a section feature 1
Modern equivalent of Autotext in Word? 0
Remove date format? 3
Sorting Date Column 1
Columns not sorting properly. 2

Top