Generating Random Numbers that Don't Change When the File is Reopened

**newbie0101** · 08-09-2012, 05:07 PM

Hello, everyone.

I need to use a Random Number Generator that generates random numbers for me, but I do not want the numbers to change once I exit the file and reopen it. How can I do this?

When I use the =RAND function, the numbers change when I reopen the file. I need them to stay the same because I am using the random numbers to sort the data in the adjacent cells.

Thanks,

newbie0101

**shg** · 08-09-2012, 05:31 PM

Copy the column and paste as values.

**tridom** · 08-09-2012, 06:51 PM

All I can find is that after you generate the number, right click the cell and select paste to paste the value.

http://www.addictivetips.com/microso...rand-function/

---------- Post added at 06:51 PM ---------- Previous post was at 06:49 PM ----------

AH! Found a better one! Simply type =RAND() in the cell and then press F9

http://www.itechtalk.com/thread10597.html