Converting Formula Results to Actual Data Values

[Guest]

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.

 

[Gord Dibben]

Copy>Paste Special>Values>OK>Esc


Gord Dibben MS Excel MVP

 

[Guest]

Copy the cells with the Formula...

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

Then Click on Values... and press ok

 

[Guest]

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

 

[Guest]

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

 

[Guest]

Thank you everyone.

I knew it was something simple.