How to multiply all cells in array by factor

I have an array from A1:ES80 which I want to multiply all cells by 10.

I know I can select another area on the spreadsheet of the same size, enter
=A1:ES80*10 and press CTL-Shift-Enter to have a new array created.

Unfortunately, this new array is now referenced to the first, and doesn't let me save just this new array (I am using CSV format so I can open in graphing/plotting programs).

Is there a way to multiply the original array so i can easily save it?

Thanks!

You can use the Paste Special/Operation/Multiply feature. Type the number 10 in a cell. Copy that. Select your entire array that you want to multiply by 10. Select Paste Special. In the Operation section of the option box, select the Multiply option and click ok. That will multiply all of your values by 10. Or, since you've already got the array with the values, you can copy and Paste Special, select Values over the original and then delete the array you created to multiply by 10.


HTH

Steve

Hey thanks!

I',m actually using Gnumeric (open source) and it's got the exact same function.
It's exactly what I was looking for. Thanks again!