Can I sort cells of postive and negative numbers in absolute order

J

John

Is it possible to sort cells of postive and negative numbers in absolute
order without changing the formatting?
 
D

David Biddulph

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.]
 
Top