range of cells from + to -

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you replace a range of cells from a positive value to a negative value.
 
Type -1 in some empty cell, and copy it. Select the range you want to
change, and Edit > Paste Special. Select the radio button for 'multiply' and
click OK.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with "SUM" AND "ABS" in same formula 12
how can I pick up a nearest value to zero 3
How do I have a cell value define a dynamic named range? 15
Reallocate array cells value from positive to negative 0
Trying to find additional ranges outside of min, max, and average 2
Red cell for negative numbers in Excel 1
VBA set thick borders around non empty cells in range 0
Select a range not equal to: 4

Back
Top