I have a large worksheet with numbers already entered onto it, as positive
numbers, however, I want to change all these to minus figures. Is there an
easy way to do this rather than having to change each figure individually?

Thank you.

Louise

Yes.

1 Put -1 in an un-used cell
2 copy the cell
3 select the group of cells you want to make negative
4 then Edit > Paste Special > and check the multiply box

All the cells in the group will be inverted.

Have a good day
--
Gary''s Student


"Louise" wrote:

> I have a large worksheet with numbers already entered onto it, as positive
> numbers, however, I want to change all these to minus figures. Is there an
> easy way to do this rather than having to change each figure individually?
>
> Thank you.
>
> Louise

Excellent!! Thank you very much.

Louise

"Gary''s Student" wrote:

> Yes.
>
> 1 Put -1 in an un-used cell
> 2 copy the cell
> 3 select the group of cells you want to make negative
> 4 then Edit > Paste Special > and check the multiply box
>
> All the cells in the group will be inverted.
>
> Have a good day
> --
> Gary''s Student
>
>
> "Louise" wrote:
>
> > I have a large worksheet with numbers already entered onto it, as positive
> > numbers, however, I want to change all these to minus figures. Is there an
> > easy way to do this rather than having to change each figure individually?
> >
> > Thank you.
> >
> > Louise