Put =ABS(A1) in a helper column. Select the whole data range (including the
helper column) and sort by the helper column.
[Changing the formatting doesn't change the value in the cell, so won't
change the sort order.]
--
David Biddulph

"John" wrote in message
...
Is it possible to sort cells of postive and negative numbers in absolute
order without changing the formatting?