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

F

Fox

Is there a Function/option to change a range of sells from negative to
positive without making the font red ?
 
D

Dave Peterson

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).
 
S

Shane Devenshire

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