Multiple RandomBetween() Numbers - Change all to Fixed Numbers

[robbertly]

Hi All,

Quick Question.

I know that I can generate Random numbers with fixed numbers using Randbetween (001,999)

If I have multiple Randbetween numbers on a sheet and want to 'keep' the numbers, how do I stop all of them refreshing / changing on opening and closing the sheet / pressing the delete / refresh button?

I know that pressing F9 fixes the value of one cell, but how do I apply that to multiple / all of the Randbetween cells on a sheet?

Any assistance much appreciated.

Thanks,

Robbert

 

[Leo Skywalker]

Hi there,
You can copy and paste especial: values.

 

[robbertly]

Hi,

Thanks for the reply.

I will give that a try...

Robbert