no i meant the actual content to be what is displayed.
if you click on the cell, and look in the = textbox in the top toolbar
it's still going to contain the formula, i want it to just contain the
result of the formula if you know what i mean?


--
kyegibbon
------------------------------------------------------------------------
kyegibbon's Profile: http://www.excelforum.com/member.php...o&userid=34335
View this thread: http://www.excelforum.com/showthread...hreadid=541032