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
editreplace
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
datatext 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
文章標籤
