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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

making # + or - based on another cells contents 2
Program buttons to create a word document 0
Change series of numbers from positive to negative 3
Automate bar chart color based on value postive or negative 1
Matching Negative and Positive Values 20
How do I make them all negative?? 2
change a currency number display 4
Showing Negative as Postive 3

Top