changing signs in formulas and cells
 

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

changing signs in formulas and cells
 

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


"johnsail" wrote:

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