View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default How to change numbers from positive to negative.

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)

--
Best Regards,

Luke M
"tammy p" wrote in message
...
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