Sorting Dates

D

dah

Hi:

Is there a way to sort dates in number order:

3/1/06
3/2/06
3/3/06
3/15/06
3/20/06
3/31/06
3/11/06

In my case the dates are sorted this way:
3/1/06
3/11/06
3/2/06
3/20/06
etc.

Any thoughts
 
M

mrsinnister

-On top of that, how do I sort by date in the format: Thursday, Marc
23, 2006 without it reverting to alphabetical order by the leftmos
item? It is delimited by commas so how do I at least sort by field
instead?
 
R

Rob Giordano \(Crash\)

try it with date format; 01/01/06


|
| Hi:
|
| Is there a way to sort dates in number order:
|
| 3/1/06
| 3/2/06
| 3/3/06
| 3/15/06
| 3/20/06
| 3/31/06
| 3/11/06
|
| In my case the dates are sorted this way:
| 3/1/06
| 3/11/06
| 3/2/06
| 3/20/06
| etc.
|
| Any thoughts?
|
|
| --
| dah
| ------------------------------------------------------------------------
| dah's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=6493
| View this thread: http://www.excelforum.com/showthread.php?threadid=525690
|
 
D

Dave Peterson

Your dates are just text masquerading as dates.

Try selecting that range and
edit|replace
what: / (slash)
with: /
replace all

Excel will see the changed entries as dates.

ps. make sure your windows short date format is m/d/y.

If you use dmy or ydm or anything else, then
select the column
data|text to columns
fixed width
erase any lines that excel guessed
and choose Date mdy
as the format

Now they'll be dates and sort as dates.
 
Top