Copying Formula

N

nc

Hi Guys

I will be grateful if you can solve my problem
Whenever i am copying formula from one worksheet to another worksheet,
it is copying the contents of formula itself (e.g. ='worksheetA'!D12)
not the formula result.

Thanks
nc
 
M

Mike

It actually copies everything, you make the choice when you paste. Try paste
special - value
 
R

Roger Govier

Hi

It sounds as though the cell you are pasting to is formatted as Text.
Try formatting the cell as General, then do the Copy/Paste
 
C

CLR

Try editing the new formula by deleting the equal sign and pressing Enter,
then editing it again and re-inserting the equal sign.........

Vaya con Dios,
Chuck, CABGx3
 
Top