Thanks, Richard. That's great.

Many thanks.

Ellie

"Richard Buttrey" wrote:

On Mon, 5 Sep 2005 07:58:04 -0700, "Ellie"
wrote:

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

Simplest way is to use a spare working column say C.

Assuming the values are in column A and the codes in column B, enter
the following in C1

=if(B1=356,a1*-1,a1)

Copy it down column C.
Then Edit Copy the whole of Column C and Edit PastSpecial Value into
Column A.

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________