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
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