Undoing formula
 

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


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=561025

Undoing formula
 

"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
---