Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SORTING A COLUMN BY DATE | Excel Discussion (Misc queries) | |||
vlookups not sorting correctly | Excel Discussion (Misc queries) | |||
Sorting numbers doesn't work correctly | New Users to Excel | |||
Pivot Table not sorting correctly | Charts and Charting in Excel | |||
Letters and 000s in front of actual number not sorting correctly | Excel Discussion (Misc queries) |