change a positive number to negative
Oops...Sorry..Copy cell Right clickPasteSpecialMultiply OK....
--
If this post helps click Yes
---------------
Jacob Skaria
"MICHALK" wrote:
"Jacob Skaria" wrote:
Try the below
--Enter -1 in a cell and copy the cell
--Keeping the copy; select the data range to be converted (say A1:A100).
--Press F5. From Goto windowSpecial select 'Multiply' and hit OK
If this post helps click Yes
---------------
Jacob Skaria
"MICHALK" wrote:
How to change a positive number to negative?
Thanks...but I don't have Multiply as an option in that menu.
|