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...fo&userid=6493
View this thread: http://www.excelforum.com/showthread...hreadid=525690

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


--
mrsinnister
------------------------------------------------------------------------
mrsinnister's Profile: http://www.excelforum.com/member.php...o&userid=32737
View this thread: http://www.excelforum.com/showthread...hreadid=525690

try it with date format; 01/01/06


"dah" wrote in message
...
|
| 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...fo&userid=6493
| View this thread: http://www.excelforum.com/showthread...hreadid=525690
|

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.

dah wrote:

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...fo&userid=6493
View this thread: http://www.excelforum.com/showthread...hreadid=525690

--

Dave Peterson