Excel Formula/Function

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

Does anyone know of an Excel formula that will change all
positive numbers on a spreadsheet to negative numbers and
all negative numbers on the same spreadsheet to positvie
numbers? Many thanks!
 
Hi

One way is to type -1 in an unused cell. Copy this. Select the range to
adjust and Paste / Special / Multiply

Andy.
 
Heather,

Enter -1 in to some empty cell and copy that cell. Then, select
the cells whose avlue you want to change. Go to the Edit menu,
choose Paste Special, and choose the Multiply option.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
No function, but put -1 in a cell, then copy that cell. Then select all of
the cells to change, Edit>PasteSpecial and check the Multiply option within
the Operation section.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
if you can find a blank cell, type in "-1"

then copy that cell. select all cells you want negative, paste specia
-> multiply.

this will reverse all positive -> negative and negative -> positive.

ht
 
Back
Top