Negative Numbers

P

PL

How do I change all the numbers in a row into positive ones without doing so
individually?

Thanks
 
A

Allllen

Hello PL,

In the row underneath you can use for example
=ABS(A1)
This gives you the positive value of what is in cell A1, no matter if what's
there is positive or negative.
Then you can extend this formula across to the right.

After this, you can use copy | pastespecial values on the new row to get rid
of the formulae.
 
J

Jacob Skaria

Suppose you have your numbers in Column A; use the below formula in ColB
cell B1 and copy that down..

=ABS(A1)

If this post helps click Yes
 
J

Joel

Use an auxillary column. If your numbers are in column A put in new column
the formula

=-1*A1

Then copy the formula down the new column. Next, copy the postive numbers
in the new column to the old column using pastespecial values.

If you have both positive and negative numbers in the original column the
use this

=if(A1<0,-1*A1,A1)
 
G

Gary''s Student

Let's assume that the row contains a mixture of positive and negative numbers.
Let's assume that we are talking about row #1.

In A2 enter:
=ABS(A1) and copy across.

Then copy row #2 and pastespecial/values back onto row #1
 
G

Gord Dibben

Enter -1 in a cell.

Copy that cell.

Select the range of negative numbers and Edit>Paste Special>Multiply>OK>Esc.

No need for helper column.


Gord Dibben MS Excel MVP
 
J

James Silverton

Gord wrote on Sat, 13 Jun 2009 06:17:59 -0700:
Copy that cell.
Click to expand...
Select the range of negative numbers and Edit>Paste
Special>Multiply>OK>Esc.
Click to expand...
No need for helper column.
Click to expand...
Gord Dibben MS Excel MVP
Click to expand...

I'll admit that the question is a bit ambiguous but the useful variant
ot Paste Special will work only if *all* the numbers in the row are
negative.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not
 
R

Ragdyer

I think if you re-read Gord's post, you'll see that he stipulated selecting
the *negative* numbers.

With the procedure he described, you can pick and choose between and among
the ranges to select *only* the negative numbers before performing the
multiplication.
 
J

James Silverton

Gord wrote on Sun, 14 Jun 2009 09:51:30 -0700:
Gord
Click to expand...

You are indeed correct! I took the word "range" in Gord's post to mean a
contiguous range. Sorry!

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not
 
Top