Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
How is that column formated? It almost sounds like some of the cells
withing that column are not all sorted the same. |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
SORTING question | New Users to Excel | |||
Adding a KeyID column for sorting | New Users to Excel |