Do instead a copy n paste special as values. Copy A3, then right-click on A2
Paste special Check "Values" OK. It won't mess up your formulas.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,700 Files:356 Subscribers:53
xdemechanik
---
"Ms_M_o_n_i_c_a" wrote:
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!