Are you trying to paste the calculated value? Then just copy--paste
special--values.

Otherwise, one thing you could do is, instead of copying and pasting, simply
link your destination cell to the calculated cell you're trying to copy.

A third option would be to put an apostrophe to the left of the formula in
question, to convert it to a text string, copy the whole thing, paste it in
the destination cell, and then delete the apostrophe.

Dave
--
Brevity is the soul of wit.


"Ninjapowa" wrote:

I have a cell with a formula in sheet1 which points to another worksheet cell
(sheet2!$A$1). Now I want to copy this cell to another cell in sheet1, but
Excel keeps shifting the cell value in my formula (sheet2!$A$2)... How can I
tell it to just copy paste normally without excel changing my formula
targets?!

thanks!