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


--
iturnrocks
------------------------------------------------------------------------
iturnrocks's Profile: http://www.excelforum.com/member.php...o&userid=37246
View this thread: http://www.excelforum.com/showthread...hreadid=570790