Help With Sorting
 

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.

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

It is kind of hard to tell what's wrong without looking at it
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 the
return values of all the dates, you might get a better idea what is
going on.


Good luck



Playa Wrote:
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.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=377075

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.