RAND number LOCKING IT?????

[Stubee]

Hi,

Im trying to lock =RAND()*1000

Everytime I go into another cell and press enter it
changes???

How can I lock it to the first random number it gets??

Thanks

 

[Jason Morin]

Copy the RAND cell, paste special > value.

HTH
Jason
Atlanta, GA

 

[Chip Pearson]

Stubee,

Select the cell, then press F2 followed F9 followed by ENTER.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com