I'd be suspicious that some of your 'dates' are acutally text values
masquerading as dates.

Check the ones that don't sort correctly, maybe even re-entering them. Then
try sorting them again

"sarjak" wrote:


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