Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hello all, I am working with a 5 column/35 line spreadsheet and need to sort the contents by date (column E). I have made sure that the column is formatted for date (ex formatcellsDATE03/01/05). When I select the columns go to DATA SORT Column e ascending it sorts up until line 30 or so then it just does the willy nilly thing. I cannot figure out why this simple function is giving me more greys. Any ideas? Thanks Tracy ![]() -- sarjak ------------------------------------------------------------------------ sarjak's Profile: http://www.excelforum.com/member.php...o&userid=29402 View this thread: http://www.excelforum.com/showthread...hreadid=496477 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting data by Date | Excel Worksheet Functions | |||
Date sorting problem | Excel Discussion (Misc queries) | |||
search for latest date | Excel Worksheet Functions | |||
Sorting by date when the date isn't exact | Excel Discussion (Misc queries) | |||
Convert 20050118 to a working date field | Excel Worksheet Functions |