Select D1 then Edit Copy
Select A1 then Edit Paste Special and check value.
--
Gary's Student


"Dave Boland" wrote:

If I have the following spreadsheet, how do I get a
calculation in D1 to put the value in A1 as well (as D1)?

A B C D
1| 2 3 =B1 + C1
2|
3|

I don't want to put the formula into A1, just the value --
'5' in this case.


Thanks,
Dave