View Single Post
  #6  
Old November 12th, 2009, 05:20 PM posted to microsoft.public.excel.misc
NonTechie
external usenet poster
 
Posts: 91
Default change a positive number to negative

Try these.
1. When entering the number, put a minus sign in front of it.
2. If your positivie number is in cell A1, enter =-a1 in, say cell b1.
3. If you have a group of mixed numbers (positive and negative), use an IF
statement in cell b1. E.g. =if(a1=0,a1,-a1) and copy.

"MICHALK" wrote:

How to change a positive number to negative?