sorting

V

vince

why when I am soring the entire database does it sort a-z
than it starts a-z again 3/4 down the data base? I want
it all a-Z

Thanks
 
P

Peo Sjoblom

Do you have mixed text and numeric values? That would explain it,
then the numeric values would sort first then the text values at the end.
Press F5, select special, constants and uncheck everything nut text and see
if the last part is text, they would get selected if they are text.

Note that I meant text numbers which is numbers that are formatted as text,
happens quite a lot if you got the data from a data base..
 
M

Mark Graesser

Vince
Maybe you have preceding spaces

Regards
Mark Graesse
[email protected]

----- vince wrote: ----

why when I am soring the entire database does it sort a-z
than it starts a-z again 3/4 down the data base? I want
it all a-

Thank
 
Top