Saving spreadsheet
 

How do you save a spreadsheet with formulas to appear as values?

Saving spreadsheet
 

You must convert the formulas to values BEFORE you save it.

Select the range of formulas, press Ctrl-C to copy them, and without
changing the selection use the menu Edit-Paste Special-Values

Then save your file


"Beginner Excel User" wrote:

How do you save a spreadsheet with formulas to appear as values?

Saving spreadsheet
 

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