change sign in range

K

Katherine

I need to change a range of numbers from positive numbers
to negative numbers. Don't know how to do a range at one
time.
 
D

Dave R.

If they are all positive--

Type -1 in a cell
copy it (ctrl c)
select the range you want to transform
edit>paste special> click operation- multiply then OK.
delete the -1 from the cell.
 
B

Bob Umlas

Works even if the values are NOT all positive!

Dave R. said:
If they are all positive--

Type -1 in a cell
copy it (ctrl c)
select the range you want to transform
edit>paste special> click operation- multiply then OK.
delete the -1 from the cell.
Click to expand...
 
A

Alex Brasil

Put -1 in a cel
Copy this cel
Select the range to past
Use Edit / Paste Special / Multipl
After that, erase the number -
 

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

Program buttons to create a word document 0
SUMIF with broken range 10
Office365 Outlook for work email change signature how ? 0
Automatically Scheduled Task with Start on Constraint and Neg Slack 0
countif 9
Finding the proper style field and the numbered paragraph value within the style 0
Paragraph numbering in Word 1
Remove Identical words 0

Top