Cell changes to a formula after hitting ENTER

[PerryK]

If I copy from a cell that has a formula in it, to an empty cell - using
copy-paste special-values -- After I hit enter, the cell contents change to
the formula that was in the original cell.

As an example - Cell A3 is "=A10"
If I copy this and then use Paste Spectial Values into Cell C3, it shows the
value, but then as soon as I hit "Enter", it changes to the formula "=C10".

It is acting like it is copying the formulas instead of the value, and
transposing the reference for the new cell location.

If I do the same thing, but hit the down arrow key after the Paste Special
Values, then it just copies the value and not the formula.

I have checked the settings in the Options Menu, but I do not see anything
that may cause this.

Thanks,

 

[Gary''s Student]

That is how it works. The ENTER key undoes the Special.

 

[Thomas [PBD]]

I guess what Gary's Student is saying is that if you dont want to paste in
the Formula, you just Copy>Paste Special>Value and DO NOT press Enter. This
will paste in the Value.

 

[PerryK]

Thanks for the quick response,

I use the PSV a lot and it didn't to do this before, or maybe I just didn't
notice it before???

 

[Gord Dibben]

I think you just didn't notice.

I always use Paste Special>Values>OK>Esc


Gord Dibben MS Excel MVP