locking the result of a formula.

C

Claire

Is there any way of copying and locking the result gained from a formula so
the result doesnt change when cells used in the formula do??
 
B

Bernard Liengme

Copy the cell; then use Edit | Paste Special with Values specified in the
dialog box
best wishes
 
Top