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,

Paste Special/ Values ?
--
David Biddulph


"MoCollins" <(E-Mail Removed)> wrote in message
news:B0E06109-1106-456F-A41E-(E-Mail Removed)...
> 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,

"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.

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,