Undoing formula

P

phil2006

If I use =sheet1!a2 to insert a value into a box on sheet two is ther
any way that I can then remove the formula in the box whilst keepin
the value?
Thanks


Phi
 
M

Max

phil2006 said:
If I use =sheet1!a2 to insert a value into a box on sheet two is there
any way that I can then remove the formula in the box whilst keeping
the value?
Click to expand...

To freeze values, just do an "in-place":
Copy > Paste special > Check "Values" > OK
 
Top