Converting a formula to a set value

  • Thread starter Thread starter S. Rosenthal
  • Start date Start date
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?
 
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
 
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
 
Back
Top