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