cell values

  • Thread starter Thread starter Derek Dainton
  • Start date Start date
D

Derek Dainton

How do you convert negative cell number entries to positive?
 
In an un-used cell enter -1 and then copy this cell. Then select the cells
you want to change and Paste/Special/Multiply
 
Derek Dainton said:
How do you convert negative cell number entries to positive?
Click to expand...

One way, assuming numbers (positives, negatives, with maybe some blank
cells) are in A2 down, you could place in B2, copied down:
=IF(A2="","",ABS(A2))

---
 
The earlier suggestion assumes that the conversion is to be applied only for
the negatives in the entire col, viz you would want to leave positives as
positives & the blanks as "blanks"

---
 
You must log in or register to reply here.

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

Red cell for negative numbers in Excel 1
Referencing a negative value 3
Flipping numeric values 3
Question about conditional formatting of zeros in Excel 0
Coloring cells 8
Excel 2002 : Any fast way of converting positive to negative numbe 2
directing a total to various cells dependent of its value 1
Reallocate array cells value from positive to negative 0

Back
Top