The last two entries in a range won't sort
How did you confirm the data to be numbers?
Simply formatting as number or general will not change the format if the
"numbers" are text.
I would add this formula in a helper column to double-check.
=ISNUMBER(cellref) do you get TRUE or FALSE?
Gord Dibben MS Excel MVP
On Sat, 8 Mar 2008 12:55:01 -0800, bibbis
wrote:
I have a list of items in an excel sheet. I sorted the items, and they sorted
fine. Then I added two items at the end of the list, but they won't sort
with the rest of the list. When I switch between ascending and descending,
the original items reverse order, but the two new entries just stay where
they were.
I've confirmed the items are all numbers, no characters.
Help!!!
|