ExcelBanter - Formula to Text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula to Text (https://www.excelbanter.com/excel-worksheet-functions/43304-formula-text.html)

WTG

Formula to Text

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

All times are GMT +1. The time now is 07:42 AM.