Pleaes note that this option will only work if you have only +ve numbers in
your selection....or else you will have to use a helper column with a
formula..

"Jacob Skaria" wrote:

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.