Hi experts,

How do I go about changing the cell formula so that it becomes the
result of the formula. Thank you!


--
sutats
------------------------------------------------------------------------
sutats's Profile: http://www.excelforum.com/member.php...o&userid=24565
View this thread: http://www.excelforum.com/showthread...hreadid=387125

Here are 2 ways to convert formulas to their values:

For 1 cell:
Select the cell, then...
Press [F2] (to edit)
Press [F9] (to convert to the value)
Press [Enter] (to commmit the value)

Or (for multiple cells)

Select the cells, then ...
Edit>Copy
Edit>Paste Special>Values

Does that help?
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=387125

Ron Coderre,

Thank you for your excellent reply, I was after the first one but
thanks for taking the time to explain both methods. Cheers!


--
sutats
------------------------------------------------------------------------
sutats's Profile: http://www.excelforum.com/member.php...o&userid=24565
View this thread: http://www.excelforum.com/showthread...hreadid=387125