View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Todd
 
Posts: n/a
Default 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.