sorting

  • Thread starter Thread starter vince
  • Start date Start date
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
 
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..
 
Vince
Maybe you have preceding spaces

Regards
Mark Graesse
(e-mail address removed)

----- 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
 
Back
Top