I've got a workbook which will assign numbers to various rows. I want to increase these numbers by a random value. The problem with the RAND function is that it recalculates itself every time I recalculate the workbook. Is there a way (other than copy/pasting hard numbers) to have all the RAND functions in a sheet operate manually, say with a button? (one button... calculates all RAND formulas, once).

Thanks!