Converting Formula Results to Actual Data Values

R

RSJ145

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

AKphidelt

Copy the cells with the Formula...

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

Then Click on Values... and press ok
 
R

Ron Coderre

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
 
Top