changing a range of positive numbers to negative

mevans

New Member
Joined
Dec 20, 2004
Messages
3
What is the easiest way to change a range of positive numbers to negatives? thanks!!
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
HEllo, mevans,
welcome here!

Type -1 in any cell
copy that cell
select the range you want to change form + to -
rightclick and choose pastevalues: in that box choose "multiply"

kind regards,
Erik
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,318
Office Version
  1. 365
Platform
  1. Windows
Well you could put -1 in a cell.

Then select that and goto Edit>Copy.

Then select the range of positive numbers tou want to change to negative numbers.

Then goto Edit>Paste Special... and then in the Operation section select Multiply.
 

Forum statistics

Threads
1,148,530
Messages
5,747,234
Members
424,070
Latest member
smanni3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top