Sorry! Skip mu previous answer - I didn't read your posting carefully
enough!
Arvi Laanemets
"Arvi Laanemets" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
Bookmarks