Undoing formula

[phil2006]

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?
Thanks


Phil

[Max]

"phil2006" wrote:
> 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?

To freeze values, just do an "in-place":
Copy > Paste special > Check "Values" > OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---