View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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