converting formula to plain data (number)

  • Thread starter Thread starter karlcsr
  • Start date Start date
K

karlcsr

Hi...first time I have posted here. I have slightly altered a long,
long column of data into a separate column that is slighly modified.
So the result in the second column might be something simple like
R1C1/2.

BUT this new column is now made of FORMULAS as opposed to hard data.
When I try to transfer this LONG column of "formulas" as opposed to
data to a different worksheet, the program won't work as it doesn't
know what the formula is referring to.

So with that background my question is: Can I convert the second
column I created to plain data? In other words the first row of the
column may display 10. I just want that cell to equal the data 10 --
NOT R1C1/2.

Thanks!
 
Copy the desired cells, select 'Paste Special' from the Edit menue and
select 'Values Only'. This should do what you want.

HTH,
Paul C.
 
PCLIVE said:
Copy the desired cells, select 'Paste Special' from the Edit menue and
select 'Values Only'. This should do what you want.

HTH,
Paul C.
Click to expand...

THANKS!!!! Works like a charm!!!
 
Back
Top