Look at the closed date (the first sort key) of the row that does not sort
correctly and is now at the bottom of the table. Is it a valid date?
Select that cell and do Format - Cells - Select the Number tab. What is the
highlighted format?
If the format is not Date but it looks like a valid date, select a blank
cell and do Edit - Copy. Then again select the bad closed date cell and do
Edit - Paste Special, select Add and click OK. Now sort the table and see
if this corrects it.
Post back if this doesn't solve it for you. Provide the detail values of
the 3 entries in the row that doesn't sort correctly. HTH Otto
"Sylvia" wrote in message
...
I have a spreadsheet that has many columns, some of which I am trying to
sort
by. One Column is called Closed Date, and is in Date Format. Another
column
is called Referred Date and is in Date Format. And another is called
Status
and is in General Format. I am sorting the spreadsheet first by Closed
Date,
then by Referred Date, then by Status. It sorts fine. nIf I correct a
date
and re-sort, it re-sorts fine. BUT, if I correct a date and a status, it
does not re-sort correctly...the changed records is at the bottom of the
spreadsheet out of the sort sequence. I just can't figure out what is
happening and why it won't re-sort. HELP!!!