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?
|