| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I prevent a RAND number from changing
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? |
|
#2
|
|||
|
|||
|
how do I prevent a RAND number from changing
Set the calc mode to Manual
(Click Tools Options Calculation tab) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "DAVIDT" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
| How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
| changing page break in an excel file | New Users to Excel | |||
| How to prevent cursor from moving behind filled cells | Excel Discussion (Misc queries) | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Linear Mode
