Hi, Kirsten. It's so frustrating when Excel doesn't recognize our data
properly. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Kirsten" wrote in message
...
I have a list that has 3 columns in it....a number column, a column for the
name, and then another colomn for where that file is. I am trying to list
in
order of the first column (which is the number column) because that is how
we
find the file. BUT, when I sort, the sorting doesnt sort right. I have
2000
numbers then 1990 numbers then more 2000 number when there shouldnt be. I
have checked all the formatting and everything seems to be the same. Can
someone help me on why this is doing this!!