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

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

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

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

Fox wrote:

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

--

Dave Peterson

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

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.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Fox" wrote:

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