how do I prevent a RAND number from changing

D

DAVIDT

Using RAND or RANDBETWEEN to randomly select a number from a specific range
allows a new random number to be calculated when any other cell is filled
and tabbed. I only want the random number to change when F9 is used. How can
this be done?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
How can I use the same random number twice in the same formula? 2
RAND function without duplicates? 3
Paragraph numbering in Word 1
What is this called in Excel or how it works? 0
Excel does not accept text format! 0
Excel VBA Macro to do this? 19

Top