If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Negative Numbers
How do I change all the numbers in a row into positive ones without doing so
individually? Thanks |
#2
|
|||
|
|||
Negative Numbers
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. -- If you found this post helpful, please click "Yes". Allllen "PL" wrote: How do I change all the numbers in a row into positive ones without doing so individually? Thanks |
#3
|
|||
|
|||
Negative Numbers
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 --------------- Jacob Skaria "PL" wrote: How do I change all the numbers in a row into positive ones without doing so individually? Thanks |
#4
|
|||
|
|||
Negative Numbers
select the row
ctrl + f find: - replace with blank. On Jun 13, 2:14*pm, PL wrote: How do I change all the numbers in a row into positive ones without doing so individually? Thanks |
#5
|
|||
|
|||
Negative Numbers
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(A10,-1*A1,A1) "PL" wrote: How do I change all the numbers in a row into positive ones without doing so individually? Thanks |
#6
|
|||
|
|||
Negative Numbers
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 -- Gary''s Student - gsnu200856 "PL" wrote: How do I change all the numbers in a row into positive ones without doing so individually? Thanks |
#7
|
|||
|
|||
Negative Numbers
use for example =ABS(A1)
-- If you found this post helpful, please click "Yes". Allllen "PL" wrote: How do I change all the numbers in a row into positive ones without doing so individually? Thanks |
#8
|
|||
|
|||
Negative Numbers
Enter -1 in a cell.
Copy that cell. Select the range of negative numbers and EditPaste SpecialMultiplyOKEsc. No need for helper column. Gord Dibben MS Excel MVP On Sat, 13 Jun 2009 02:14:01 -0700, PL wrote: How do I change all the numbers in a row into positive ones without doing so individually? Thanks |
#9
|
|||
|
|||
Negative Numbers
Gord wrote on Sat, 13 Jun 2009 06:17:59 -0700:
Copy that cell. Select the range of negative numbers and EditPaste SpecialMultiplyOKEsc. No need for helper column. Gord Dibben MS Excel MVP On Sat, 13 Jun 2009 02:14:01 -0700, PL wrote: How do I change all the numbers in a row into positive ones without doing so individually? 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 |
#10
|
|||
|
|||
Negative Numbers
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. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "James Silverton" wrote in message ... Gord wrote on Sat, 13 Jun 2009 06:17:59 -0700: Copy that cell. Select the range of negative numbers and EditPaste SpecialMultiplyOKEsc. No need for helper column. Gord Dibben MS Excel MVP On Sat, 13 Jun 2009 02:14:01 -0700, PL wrote: How do I change all the numbers in a row into positive ones without doing so individually? 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 |
|
Thread Tools | |
Display Modes | |
|
|