Random Numbers
Posted by Eric on November 04, 2001 8:51 AM
I am using the RANDBETWEEN command to produce random
numbers. My question is:
Is there a command that I can type into a cell to
lock in a random number once it is produced, so it
won't keep making new numbers everytime I enter
something in another cell?
eric
Posted by Dan on November 05, 2001 11:01 AM
I don't believe that there is a command you can just type in to a cell, because the Randbetween command is supposed to give a new number whenever there is a calculation anywhere on the sheet.
You could try creating a macro that pastes the value either in a new cell (if you want to keep the original Randbetween formula) or pastes it back in to the original cell (and you would lose the formula).
