MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sorting problem


Posted by David on August 15, 2000 2:36 AM

Is there any reason anyone can think of where sorting wouldn't work

I have a list of close to 600 serial numbers. Most are numbers but some start with letters. When I sort there are always a few numbers at the beginning of the list that just don't belong there. They belong further down on the list. Any clues.
They are formatted as general none are formula's or links. They are selected in the sort. This is how the list starts. After 0000 they are fine.

1212
11022
90600
101328
139006
6828003
50813503
96003606
98000574
98001578
98263040
0000
0000524
0008698


Posted by Celia on August 15, 0100 4:28 AM

524

David
Possibly you've got some "spaces" at the front of the numbers. Try deleting the spaces and formatting again as General.
Celia