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.
 

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

Program buttons to create a word document 0
SUMIF with broken range 10
Linking Equations to Highlights 2
How to change numbers from positive to negative. 2
Subtracting positive amts from negative and positive from positive 3
How do I have a cell value define a dynamic named range? 15
Negative value to positive 13
How to make scroll bar permanently visible, Word 365 0

Top