Copy column to another spreadsheet but get value errors
 

I'm trying to copy a column from one spreadsheet to another but because the
cells contain functions, I get the #VALUE! error. How can I copy the cells
without this happening? Is there a way to convert the function to text?
Thanks,

Copy column to another spreadsheet but get value errors
 

Paste Special/ Values ?
--
David Biddulph


"MoCollins" wrote in message
...
I'm trying to copy a column from one spreadsheet to another but because
the
cells contain functions, I get the #VALUE! error. How can I copy the
cells
without this happening? Is there a way to convert the function to text?
Thanks,

Copy column to another spreadsheet but get value errors
 

"MoCollins" wrote:

I'm trying to copy a column from one spreadsheet to another but because the
cells contain functions, I get the #VALUE! error. How can I copy the cells
without this happening? Is there a way to convert the function to text?
Thanks,


Each time you move a cell with formulars, you move the links as well. In
your case, by so doing you make excel think within an empty box, hence it
returns error!

This what you do, copy the column - and paste as values in the new worksheet
(right click your mouse, point to paste special, click on values on the left
side of the dialogue box and OK).

you should be fine now.

Copy column to another spreadsheet but get value errors
 

Thanks, the Paste Special / Value is exactly what I was looking for. Thanks!

"MoCollins" wrote:

I'm trying to copy a column from one spreadsheet to another but because the
cells contain functions, I get the #VALUE! error. How can I copy the cells
without this happening? Is there a way to convert the function to text?
Thanks,