software

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: www.excelforum.com/member.php...foamp;userid=6493
View this thread: 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: www.excelforum.com/member.php...oamp;userid=32737
View this thread: www.excelforum.com/showthread...hreadid=525690try it with date format; 01/01/06quot;dahquot; gt; 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:
www.excelforum.com/member.php...foamp;userid=6493
| View this thread: 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:
gt;
gt; Hi:
gt;
gt; Is there a way to sort dates in number order:
gt;
gt; 3/1/06
gt; 3/2/06
gt; 3/3/06
gt; 3/15/06
gt; 3/20/06
gt; 3/31/06
gt; 3/11/06
gt;
gt; In my case the dates are sorted this way:
gt; 3/1/06
gt; 3/11/06
gt; 3/2/06
gt; 3/20/06
gt; etc.
gt;
gt; Any thoughts?
gt;
gt; --
gt; dah
gt; ------------------------------------------------------------------------
gt; dah's Profile: www.excelforum.com/member.php...foamp;userid=6493
gt; View this thread: www.excelforum.com/showthread...hreadid=525690

--

Dave Peterson