Two ways.

Either copy the random values and then EditPastespecial and check Values,

or

First, goto ToolsOptionsCalculation and check the Iteration box to stop
the circular references message, and then in A1, use

=IF($B$1<"",A1,RAND())

copy this down as far as you want. This will recalculate until you enter a
value in B1, it will then lock.

With the second method, any real circular references messages will be
suppressed.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"hello_lpc" wrote
in message ...

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