Thread: Random Number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
B. R.Ramachandran
 
Posts: n/a
Default 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.