OK, I found the Paste-Special menu, which allows me to paste as a value (not linked) or even to multiply the source by the destination value!
Thanks for the help.
Thanks for the reply.
I've tried all types of =10*, =A1*10, =indirect(a1)*10 and can't seem to modify the cell contents. I keep getting invalid expression, or 0 for the answer.
Copy/paste would be fine too, but the new/multiplied array is still referenced to the first. Is there a way to make...
I'm using Gnumeric and other open-source spreadsheets.
What would be the general procedure to multiply all cells by a constant?
My array is A1:ES80 and I want to multiply all by 10. I know I can select a new area of the same size and type =A1:ES80 * 10, Ctrl-Shift-Enter. However then the new...
