Formula to Text

[WTG]

I have a cell on one sheet that sums up a col. [=sum(a11:a25)].

now I want to copy that total to a data sheet, but it keeps coming up
as #value.

How do I change the formula from one sheet to a value on another
sheet?


Thanks

[Duke Carey]

After you have copied it and moved to the destination cell, from the menu
choose

Edit->Paste Special->Values

"WTG" wrote:

> I have a cell on one sheet that sums up a col. [=sum(a11:a25)].
>
> now I want to copy that total to a data sheet, but it keeps coming up
> as #value.
>
> How do I change the formula from one sheet to a value on another
> sheet?
>
>
> Thanks
>
>