In Excel - reverse the sign on a range of numeric cells
 

I want to effect a mass change to the sign of numeric values in a range of
cells (rows and columns).

In Excel - reverse the sign on a range of numeric cells
 

put -1 in an empty cell, copy it, select the range of cells to be
modified, select Paste Special and pick Multiply.

MaryKaye wrote:

I want to effect a mass change to the sign of numeric values in a range of
cells (rows and columns).

In Excel - reverse the sign on a range of numeric cells
 

Put -1 in an un-used cell and copy it. Then select the cells you want to
update and:

Edit PasteSpecial multiply
--
Gary''s Student - gsnu201001


"MaryKaye" wrote:

I want to effect a mass change to the sign of numeric values in a range of
cells (rows and columns).

In Excel - reverse the sign on a range of numeric cells
 

You need to multiply all of the cells by -1. Find an empty cell
somewhere, out of the range that you intend to change, and put -1 into
that cell. Select the cell and then click <copy. Then move the cursor
and highlight all the cells that you want to change. Right-click in
that area and select Paste Special, then Values (check) and Multiply
(check), then OK followed by <Esc. Then you can delete the -1 from
the original cell.

Hope this helps.

Pete

On Feb 18, 7:25*pm, MaryKaye
wrote:
I want to effect a mass change to the sign of numeric values in a range of
cells (rows and columns).