In , David Biddulph <groups
[at] biddulph.org.uk spake thusly:

To multiply the values doesn't need a formula and then Paste
Special/ Values; you can use Paste Special/ Multiply.

How does that work, by the way? I've seen that menu item but
never used it. I just tried it on a cell, copying a value
with Ctrl-C and pasting it in place with my right mouse button
and selecting Paste Special. If I choose "Multiply," the
value gets squared. I don't see how to multiply the value
by a number of my choosing (e.g., -1). I'm sure this is
simple, but it's eluding me now that you got me to try it out.

--
dman