View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hello_lpc
 
Posts: n/a
Default How to 'freeze' the output generated by RAND()?


Hi all,
This is my first post in this forum and I wonder if anyone could help
me...

I have a column(a1:A11) of numbers generated by RAND(). But it is
really
annoying that it will re-calculate the outputs everytime!
Is it possible to use RAND() to randomise for one time only??

THANKS!

George Lin


--
hello_lpc
------------------------------------------------------------------------
hello_lpc's Profile: http://www.excelforum.com/member.php...o&userid=31304
View this thread: http://www.excelforum.com/showthread...hreadid=509935