Results of a Formula As a Value in New Spreadsheet

[puppypants]

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!
Thanks...

 

[JE McGimpsey]

One way:

Edit/Paste Special, select the Values radio button.

 

[Ron Coderre]

Try this:

Select the source cells
Edit>Copy
Select the destination cell
Edit>Paste Special>
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron

 

[puppypants]

Thanks - that was the help I needed. Once again, you fine folks here
saved the day for me!

 

[bk]

paste special "values" work fine as a manual solution but how can I assign an
instantaneous cell value as part of as formula?

 

[Peo Sjoblom]

Do you mean that when you enter the formula it will become static?
Not possible, you can trick some formulas by using iteration like in this
example

http://www.mcgimpsey.com/excel/timestamp.html

look at the "using circular reference" part, otherwise you would need code

--

Regards,

Peo Sjoblom

paste special "values" work fine as a manual solution but how can I assign an
instantaneous cell value as part of as formula?

Try this:

Select the source cells
Edit>Copy
Select the destination cell
Edit>Paste Special>
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron

 

[bk]

i haven't explained myself clearly. i want to interrogate a cell whose
values are constantly being updated and store that instantaneous value as a
constant elsewhere. an analogy might be storing lap times in addition to
total time.

Do you mean that when you enter the formula it will become static?
Not possible, you can trick some formulas by using iteration like in this
example

http://www.mcgimpsey.com/excel/timestamp.html

look at the "using circular reference" part, otherwise you would need code

--

Regards,

Peo Sjoblom

paste special "values" work fine as a manual solution but how can I assign an
instantaneous cell value as part of as formula?

Try this:

Select the source cells
Edit>Copy
Select the destination cell
Edit>Paste Special>
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron