Must likely those clients have a leading blank space, what you should do is
do a find and replace of the blank space before you do the sorting.
Or insert a column and place the trim function in it then do a copy paste
values on the source columns to eliminate non printable characters then
proceed to sort.

Example
A1 B1
123 =Trim(a1)




--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"SJC" wrote:

I have a spreadsheet which displays data in rows for about 350 different
clients. Each client has an assigned number which leads each row. When I
sort the rows so that they will appear in numerical order, the majority of
the rows are sorted correctly, but about 30 rows are brought to the top of
the spreadsheet out of order. Besides cutting and pasting them where they
belong, are there any other options for fixing this sorting problem?