View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default How to save random numbers?

wrote:
I have been able to generate numbers from 1 to 100 with two
decimal places but I can't figure out how to create a history
of previously generated numbers.


Enter the following formula into A1:

=RANDBETWEEN(100,10000)/100

Copy A1 into A2:A1000. Copy A1:A1000, then use Paste-Special-Value to put
the values (not the formulas) back into A1:A1000 or somewhere else.