If you want to permanently change the formulas to values, select the
range of formulas and choose Edit/Copy. Then choose Edit/Paste Special
and click against Values and then click OK. So for instance =1+2 would
be permanently converted to 3.

Beginner Excel User Wrote:
How do you save a spreadsheet with formulas to appear as values?


--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=524993