Converting a formula to a set value

S

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?
 
M

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?
Click to expand...

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

Marian
 
P

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
 
Top