Don't think you can do it in one step. If you don't get a better answer,
insert a "helper" column to create the absolute value of your data. Then sort
by the helper and delete it.

"Teddy-B" wrote:

Is it possible? I want to sort a list in excell by absolute value so that the
number 3 will be above -3 (or its closest match) and the number 990 will be
above -990 (or its closest match).

Thanks