Help With Sorting

P

Playa

I am trying to sort some cells on my worksheet and am having problems. The
column I am trying to sort has a date format. I highlight all the rows and
columns of data and go to Data -> Sort but when I select the column it
doesn't sort the dates right and sometimes it even changes half of my date
formats to another style. Anyone know what would cause this? Thanks in
advance.
 
D

DNA

How is that column formated? It almost sounds like some of the cells
withing that column are not all sorted the same.
 
M

Morrigan

It is kind of hard to tell what's wrong without looking at i
physically. However, you can try pick an empty column and do this:

=VALUE(Date)

It will return a numeric value which Excel uses to sort. Compare th
return values of all the dates, you might get a better idea what i
going on.


Good luck
 
D

DNA

Okay, here's what I just tried. I formatted my column to be in a Date
format. I keyed a variety of dates (out of order). I then sorted that
column ascending. That worked fine for me; guess I'm missing something
here.
 
Top