How to change numbers from positive to negative.

  • Thread starter Thread starter tammy p
  • Start date Start date
T

tammy p

not sure if there is an easy way to do this other than physically rekeying
the number. is there a formula or something for me to use to change a number
from being positive to negative? example: 262.00 change to -262.00 or vice
versa change from negative to positive. thanks
 
--Enter -1 in a cell. Copy the cell
--Keeping the copy select the number range
--Right click>PasteSpecial>select 'Multiply' and click OK
 
You can simply do:
=-A2

to reverse the sign of any number, or if you want all positive numbers:
=ABS(A2)

all negative numbers:
=-ABS(A2)
 
Back
Top