View Single Post
  #9  
Old November 12th, 2009, 05:26 PM posted to microsoft.public.excel.misc
David Biddulph
external usenet poster
 
Posts: 8,714
Default change a positive number to negative

If your postitive number is in A1, =-A1 will give you the negative number.
Otherwise you put -1 in a spare cell, Copy, then select the cell(s)
containing your positive number(s), and Edit/ Paste Special/ Multiply (or
Divide).

The simple thing to remember is that Excel uses a hyphen as a minus sign.
--
David Biddulph

"MICHALK" wrote in message
...
How to change a positive number to negative?