Sorting zeros

[Guest]

Im wanting to sort a series of lists that contain zeros, positive and
negative numbers also. I want the zero's to be excluded from the sort. I
have also built formulas to ommitt the zeros and pasted special values and
the sort continues to seperate the positive from the negative by the gap
created by the zeros. Any other suggestions?

 

[Guest]

Maybe this would be acceptable:

Set up AutoFilter, then use the 'Custom' option to set up to display only
values that are Not Equal to zero. Sort and you won't have any zeros in the
list.