One way:

Edit/Paste Special, select the Values radio button.

In article ,
puppypants
wrote:

Is there a way to take the results of a formula and simply paste the
result as a numeric value in a new spreadsheet? I have pricing that is
the result of a formula, but need to start a new spreadsheet with new
pricing that is calculated from the previous pricing. HELP!