Sounds like the cells you're pasting into are formatted as Text. XL
doesn't parse Text entries.

Format the target cells as General.

In article ,
Todd wrote:

I am having trouble putting formulas into a cell. I copy a formula into a
cell and then the cell I copied it froms formatting changes the moment I
press return to leave the cell. It shows the formula not the result. This
happens in both the cell I copied from and paste into. The only way I know
to set things correct os to undo.

What is happenning?