Hi,

It looks to me as if your co-worker has numbers and text that look like
numbers in this column.

Put a 1 in a spare cell and copy it. Remove the filter and select the entire
data range and then

Edit|Paste Special - Select Multiply and click OK
Delete the 1 you put in the cell, apply the filter and have another go at
the sort.

Mike

"JoAnn" wrote:

Hello,

I have a coworker who did a filter on her spreadsheet (so the blanks were
not visable) and then did a sort ascending by the sequence number. What she
got was a sort that was like this: 1, 10,100,1000, 491, 3, and so on. What
the heck is going on?!?