how can I globally change minus numbers to positive ones?

  • Thread starter Bernard Liengme
  • Start date
B

Bernard Liengme

If the numbers are in a contiguous range:
Type -1 in an empty cell; copy it; select the range of negative numbers and
use Edit|Past Special->multiply. Now delete the cell with -1.

If the numbers are in a column mixed in with positive: insert a helper
column; In top cell of helper column enter =ABS(A1) ... change A1 to fit
your situation
Copy this down the column; Now use Copy and Paste Special but this time
specify Values. Now you have a column of positive numbers and can delete the
original column.

Any help?
 

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

Excel does not accept text format! 0
Conditional Formatting based on positive/negative numbers 3
How do I change credits to debits in Excel 2
Excel 2002 : Any fast way of converting positive to negative numbe 2
Finding the Percentage % in 2 Numbers 2
How do I convert a column of numbers from positive to negative? 3
How do I display a "+" in front on positive numbers 3
Subtotal data excluding negitive numbers. 3

Top