Question: I need to find a way to automatically copy the output of the below GoogleFinance formula into another cell and make it stick, i.e. doesn't change when the exchange rate changes.

```
=A1*GOOGLEFINANCE("currency:AUDGBP")

```

I was going to use something like `=value(x)` but this would change every time the above formula generated a new value, whereas I want something to stick as soon as it's output an answer.

Answer: 
There are many options, including:

* `Ctrl`+`C` followed by `Ctrl`+
`Shift`+`V` (but could be tedious)
* GAS (with help for which SO expects some demonstration of effort on your part - or already answered)
* turn on iterative calculation (but in your case seems inadvisable)
* *perhaps* the [Spreadsheet Freezer](https://webapps.stackexchange.com/questions/129211/how-do-i-install-spreadsheet-freezer) add-on from one of our esteemed members (I've not tried it)
if you want to play with button and script then:

```
function moveValuesOnly() { var ss = SpreadsheetApp.getActiveSpreadsheet();
                            var source = ss.getRange('Sheet1!A1');
                            source.copyTo(ss.getRange('Sheet2!A1'), {contentsOnly: true}); }

```

which will copy the value from **Sheet1!A1** into **Sheet2!A1**

---

otherwise `**`CTRL`**` + `**`C`**` and `**`CTRL`**` +
 `**`SHIFT`**` + `**`V`**` for manual copy