how do I change a range of cells with - totals to positive ?

  • Thread starter Thread starter Fox
  • Start date Start date
F

Fox

Is there a Function/option to change a range of sells from negative to
positive without making the font red ?
 
You can use a helper cell (or a column of helper cells) which would contain
formulas like:

=abs(a1)

This returns the absolute value of a number. It'll always be non-negative
(greater than or equal to 0).
 
Hi,

I'm not sure what this thing about making the font red has to do with
anything?

If you want to change negative numbers to positive number then:

1. Enter -1 in a blank cell
2. Copy that cell
3. Select all the negative cells and choose Edit, Paste Special, Multiply.
 

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

how can I pick up a nearest value to zero 3
Linking Equations to Highlights 2
How to change numbers from positive to negative. 2
finding maximum, minimum in a range consists both Positive and Negative numbers 2
Subtracting positive amts from negative and positive from positive 3
How do I have a cell value define a dynamic named range? 15
Need Help with "SUM" AND "ABS" in same formula 12
Excel: want neg numbers to show red/pos green via if-then formula 3

Back
Top