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


--
puppypants
------------------------------------------------------------------------
puppypants's Profile: http://www.excelforum.com/member.php...o&userid=28654
View this thread: http://www.excelforum.com/showthread...hreadid=499894

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!

Try this:

Select the source cells
EditCopy
Select the destination cell
EditPaste Special
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=499894

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


--
puppypants
------------------------------------------------------------------------
puppypants's Profile: http://www.excelforum.com/member.php...o&userid=28654
View this thread: http://www.excelforum.com/showthread...hreadid=499894

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

"Ron Coderre" wrote:


Try this:

Select the source cells
EditCopy
Select the destination cell
EditPaste Special
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=499894

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

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

"Ron Coderre" wrote:


Try this:

Select the source cells
EditCopy
Select the destination cell
EditPaste Special
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread:
http://www.excelforum.com/showthread...hreadid=499894

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.

"Peo Sjoblom" wrote:

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

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

"Ron Coderre" wrote:


Try this:

Select the source cells
EditCopy
Select the destination cell
EditPaste Special
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread:
http://www.excelforum.com/showthread...hreadid=499894