You would need a help column, you can insert a temporary help column and use
a formula like


=ABS(A1)


copy down, select both columns and sort by the help column descending


--
Regards,

Peo Sjoblom

(No private emails please)


"bangbanjo" wrote in message
...
I need to sort a column of number values by the value ignoring negatives
and
positives. Example take the list:

-5000
-4000
-1500
1500
4000
5000

and sort into this list
-5000
5000
-4000
4000
-1500
1500