You need to convert the numbers from Text values to numeric values.

Select a blank cell. Copy it. Select your column of numbers. Choose
Edit/Paste Special, selecting the Add and Values radio buttons. Click OK.

That will coerce text "numbers" to numeric and you should be able to
sort.


In article ,
"Janice Lee via OfficeKB.com" wrote:

But it didn't happen with sort. I then copied the whole column and past
specile values to get rid of ="number" format, and then resorted, and
it's still the same.

When I double clicked each cell and pressed "enter," then the sorting
happense correctly. But I can't go through thousands of rows like this.