cell format changes when formula copied?
 

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?


Thanks.

cell format changes when formula copied?
 

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?