How to convert formulas to values

Let’s take a look.

In this case, We’ll use 1 and 4, because we want four groups.

But notice howRANDBETWEENrecalculates whenever we change anything in the worksheet.

With each change, we get a new set of random numbers.

The simplest way is to replace the formulas in each cell with the values that have already been calculated.

Just edit the cell, put the cursor in the formula, then press F9.

First, select all the cells that contain formulas, and copy the selection.

Next, initiate the Paste Special dialog and select Values.

When you click OK, Excel will overwrite the formulas with their values.

Now when we check the cells, we can see that the formulas are gone.

Use this approach whenever you want to replace live formulas with static results.