ExcelBanter - Random Number

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Random Number (https://www.excelbanter.com/excel-worksheet-functions/72679-random-number.html)

Steven

Random Number

I've created a spredsheet using the Rand function but everytime I do
something the numbers change. How do i freeze the numbers generated or remove
the function but leave the number generated.

B. R.Ramachandran

Random Number

Hi,

Select the range (column/row) containing the random numbers -- Right-click
"Copy" -- Right-click "Paste Special" -- "Values" -- "OK".

Regards,
B. R. Ramachandran

"Steven" wrote:

I've created a spredsheet using the Rand function but everytime I do
something the numbers change. How do i freeze the numbers generated or remove
the function but leave the number generated.

All times are GMT +1. The time now is 01:15 PM.