Negative Numbers

[PL]

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

Thanks

 

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

 

[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

 

[muddan madhu]

select the row
ctrl + f
find: -
replace with blank.

 

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

 

[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

 

[Allllen]

use for example =ABS(A1)

 

[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

 

[James Silverton]

Gord wrote on Sat, 13 Jun 2009 06:17:59 -0700:

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

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

 

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

 

[Gord Dibben]

Thanks RD


Gord

 

[James Silverton]

Gord wrote on Sun, 14 Jun 2009 09:51:30 -0700:

Gord

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