Converting Formula Results to Actual Data Values
 

Is there a way to convert the result of a formula into an actual data value
instead of the cell containing the formula itself when copied?

Any help would be appreciated.

Thank You.

Converting Formula Results to Actual Data Values
 

CopyPaste SpecialValuesOKEsc


Gord Dibben MS Excel MVP

On Tue, 15 May 2007 17:29:00 -0700, RSJ145
wrote:

Is there a way to convert the result of a formula into an actual data value
instead of the cell containing the formula itself when copied?

Any help would be appreciated.

Thank You.

Converting Formula Results to Actual Data Values
 

Copy the cells with the Formula...

Right Click on the mouse, go to Paste Special...

Then Click on Values... and press ok

"RSJ145" wrote:

Is there a way to convert the result of a formula into an actual data value
instead of the cell containing the formula itself when copied?

Any help would be appreciated.

Thank You.

Converting Formula Results to Actual Data Values
 

I forgot to tell you that you have to copy the data first

"RSJ145" wrote:

Is there a way to convert the result of a formula into an actual data value
instead of the cell containing the formula itself when copied?

Any help would be appreciated.

Thank You.

Converting Formula Results to Actual Data Values
 

Try this:

Select the formula cells

From the Excel main menu: <edit<copy

Select the destination cells

<edit<paste special.....Check: Values......Click [OK]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"RSJ145" wrote:

Is there a way to convert the result of a formula into an actual data value
instead of the cell containing the formula itself when copied?

Any help would be appreciated.

Thank You.

Converting Formula Results to Actual Data Values
 

Thank you everyone.

I knew it was something simple.

"RSJ145" wrote:

Is there a way to convert the result of a formula into an actual data value
instead of the cell containing the formula itself when copied?

Any help would be appreciated.

Thank You.