Converting a formula to a set value

[S. Rosenthal]

I would like to export some figures that are calculations
into another file, but have only the fixed values (i.e.
eliminate the forumlas) when I export the data. How is
this done?

 

[Marian]

S. Rosenthal napsal(a):

I would like to export some figures that are calculations
into another file, but have only the fixed values (i.e.
eliminate the forumlas) when I export the data. How is
this done?

Select cells, copy them and select the target. Use right mouse button
and choose Paste special - Values. That's all.

Marian

 

[David Hager]

Use Copy/Paste Special [Values].

David Hager
Excel FMVP

 

[Peo Sjoblom]

You can copy them and the do edit>paste special as values.
If you do this on a regular basis you might want to
automate it using VBA..


Regards,

Peo Sjoblom