Cell changes to a formula after hitting ENTER
 

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,
--
Perry K

Cell changes to a formula after hitting ENTER
 

That is how it works. The ENTER key undoes the Special.
--
Gary''s Student - gsnu200806


"PerryK" wrote:

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,
--
Perry K

Cell changes to a formula after hitting ENTER
 

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

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''''Yes'''' below.


"Gary''s Student" wrote:

That is how it works. The ENTER key undoes the Special.
--
Gary''s Student - gsnu200806


"PerryK" wrote:

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,
--
Perry K

Cell changes to a formula after hitting ENTER
 

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???
--
Perry K


"Gary''s Student" wrote:

That is how it works. The ENTER key undoes the Special.
--
Gary''s Student - gsnu200806


"PerryK" wrote:

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,
--
Perry K

Cell changes to a formula after hitting ENTER
 

I think you just didn't notice.

I always use Paste SpecialValuesOKEsc


Gord Dibben MS Excel MVP

On Wed, 8 Oct 2008 07:14:34 -0700, PerryK
wrote:

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???