Hi

Select all cells with data.
From Edit menu, select Replace, into SearchFor field enter 356, into
ReplaceWith field enter -356, and click on ReplaceAll button.


Arvi Laanemets



"Ellie" wrote in message
...
I have a column with 2 reason codes in. One is 256, which gives in a
preceding column a positive number. The other is 356, which in the same
preceding column is also giving a positive number, which should actually
be
shown as a negative number. All these figures are random.

Is there any way of changing the several hundred rows with reason code 356
to show the quantity figure as being a negative?

Ellie