Joe,

If you have stuff in addition to a date in a cell, then it's text, not a number, and it'll
sort alphanumerically, not in date sequence. You've made your job difficult by combining
the date with other stuff. And your dates don't have a consistent character count (you
didn't use 04/06/2008). Try this in a helper column. It presumes a space after the date.
Format it for a date format (Format - Cells - Number - Date). Sort on that column:

=DATEVALUE(LEFT(A2,SEARCH(" ",A2,1)-1))
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Joe" wrote in message
...
I'm trying to sort a spreadsheet by a column that begins with a date
but has other information in the cell. When I sort by ascending it
begins with the cells that don't have any dates preceding the
alphabetical content then it will start with "4/6/2008 then 4/2/2008
then 4/10/2008, then it works it's way down to the March dates
correctly. Is there any way I can get it to straighten out April so
the most recent dates sort from the top? I checked to see if there
were any spaces before the dates and there weren't. Is there anything
else I should check for that would make it sort out of order?