Sorry! Skip mu previous answer - I didn't read your posting carefully
enough!


Arvi Laanemets


"Arvi Laanemets" wrote in message
...
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