View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Reverse + and - signs

hi
not a built in function. traditionally this is usually accomplished by
simple multipling by a negative one. say your number are in column A.
=A1*-1
if 5 were in A1, the formula would return -5, thus changing the sign of the
number from positive to negative and vice versa.

Regards
FSt1

"C" wrote:

I have a sheet that I need to show my negatives as positives and vice versa.
Is there a function that can perform this for me?