Rand() function

Copper Contributor

How do I copy a cell with Rand() function into another cell without the original cell changing numbers?

2 Replies


You could set Calculation Options on the Formulas tab of the ribbon to Manual temporarily.

But as soon as you set it to Automatic again, the formulas in both the source cell and target cell will be recalculated.

@HansVogelaar Thank you for your quick and helpful advise.  It has helped a lot.