changing signs in formulas and cells

J

johnsail

Hi
I have a range of cells (A1:H100) containing a mixture of entries:-
a) cells containing formulae eg: =23-4+6 (plus and minus only - no multiply
or divide)
b) cells containing single positive amounts eg 705 (ie no sign)
c) cells containing single negative amounts eg -1500

I need to reverse the signs in all three types of entry so that:-
(a) becomes =-23+4-6
(b) becomes -705 . . . . . . . and
(c) becomes +1500 (or just 1500)

I have exhausted (I think) all ways of using the "replace" edit function and
have succeeded in changing all but the (b) type cells.

Can anyone help achive the required result?

Regards
John
 
F

FSt1

hi
in a cell off to the side, enter a negative one (-1). copy it.
high light the range you wish to change signs.
on the menu bar....
edit> paste special >under operations - check multiply> oK

done.

regards
FSt1
 
Top