How do I Stop RAND() recalculating each time I open spreadsheet
P Peo Sjoblom May 1, 2005 #2 You can't, you can copy and paste the formulas as values when you are done or you can set calculation to manual and recalculate using F9. If you do the latter you have to remember that you turned automatic off when you work with other formulas
You can't, you can copy and paste the formulas as values when you are done or you can set calculation to manual and recalculate using F9. If you do the latter you have to remember that you turned automatic off when you work with other formulas
D Dave Peterson May 1, 2005 #3 Convert it to values??? select your range edit|copy Edit|paste special|values
