I find myself converting formulas to text frequently so I can copy/paste them without the forumlas updating, then formatting back to general.

When I do this, the value still shows the text format until I open and close(double click cell- press enter) each cell. How do I get the values to show up without that?

TIA