"Jacob Skaria" wrote:

Michal, Are you sure you entered -1 to a cell and copied the cell and
***selected *** the +ve numbers to be converted and did the paste
special...It works even if the number cells are formatted to text..


"MICHALK" wrote:



"Jacob Skaria" wrote:

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.

Paste special....
OK......but that doesn't change the positive # that's already there.

Jacob,

Thank you soooo much. Followed your advice and hit escape and it worked!!!