Negative Numbers
How do I change all the numbers in a row into positive ones without doing so
individually? Thanks |
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 |
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 |
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 |
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(A1<0,-1*A1,A1) "PL" wrote: How do I change all the numbers in a row into positive ones without doing so individually? Thanks |
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 |
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 |
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 |
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 |
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 |
Negative Numbers
Thanks RD
Gord On Sat, 13 Jun 2009 18:21:05 -0700, "Ragdyer" wrote: 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. |
Negative Numbers
Gord wrote on Sun, 14 Jun 2009 09:51:30 -0700:
Gord On Sat, 13 Jun 2009 18:21:05 -0700, "Ragdyer" wrote: 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. 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 |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com