smittycft99
Board Regular
- Joined
- Apr 16, 2002
- Messages
- 128
I have a calculation in the cell
I have tools/options/calculate on manual
formula: =INDEX(A1:A20,RANDBETWEEN(1,COUNTA(A1:A20))) ..thanks Aladin.
I obtain a value, but when I go to save the file, the worksheet recalculates and changes the value.
Is there a way once I get my calculated value to erase the formula behind the cell and keep the value?
Thanks in advance!
I have tools/options/calculate on manual
formula: =INDEX(A1:A20,RANDBETWEEN(1,COUNTA(A1:A20))) ..thanks Aladin.
I obtain a value, but when I go to save the file, the worksheet recalculates and changes the value.
Is there a way once I get my calculated value to erase the formula behind the cell and keep the value?
Thanks in advance!