View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Don't want to constantly update Random numbers

Select and Copy the range
Then Use Edit | Paste Special - Values to convert formulas to values
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ApeMan" wrote in message
...
Hi, I have a worksheet with thousands of random numbers being generated.
But
it takes a while for all the boxes/formulas to update every time I change
a
single box in the worksheet. Can I somehow force it to NOT UPDATE these
random numbers every time? Besides, I'd prefer if the numbers would not
change, because then I have to adjust my plots every time they update. It
would be more convenient if all my random numbers just stayed the same
from
now on. Can I do this?

Thanks,

ApeMan