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

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

"nc" wrote:

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

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

--
Regards

Roger Govier


"nc" wrote in message
oups.com...
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

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


"nc" wrote in message
oups.com...
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