How do I convert formulas to values? Help appreciated!

  • Thread starter Thread starter Smitty
  • Start date Start date
S

Smitty

Is there a way for me to formulas to values or the result?
I have to upload this into another program and it does
not like the formulas however will take alpha-numeric
cells.

Any help would be appreciated.
 
Hi Smitty,

Press Control + A to select the entire contents of the sheet and then go to
Edit-->Copy. Then go to Edit-->Paste Special and paste Values.

Please be sure to make a backup copy of your file so that you do have the
formulae somewhere in case you need them again. Either that or do the paste
special-->Values into a new workbook.

HTH,
Katherine
 
Copy the entire spreadsheet into a new one, but paste as "special paste"
values.

--
Ken Russell

| Is there a way for me to formulas to values or the result?
| I have to upload this into another program and it does
| not like the formulas however will take alpha-numeric
| cells.
|
| Any help would be appreciated.
 
Back
Top