View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ms_M_o_n_i_c_a Ms_M_o_n_i_c_a is offline
external usenet poster
 
Posts: 13
Default cut & paste made the cell with forumla #ref

how do i stop this from happening?

example: a1 equals a2 but when I cut from a3 and paste to a2, a1 turns into
#ref.

i want a1 to equal a2 no matter what

I seen a thread on this the other day and thought i printed it
--
I will Excel at Excel!