Changing formula to value/result

  • Thread starter Thread starter sutats
  • Start date Start date
S

sutats

Hi experts,

How do I go about changing the cell formula so that it becomes the
result of the formula. Thank you!
 
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,

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