Clarification.... I wrote:
"Robinsg" wrote:
From the Paste Special menu I change the Paste option
from All to Values, Operation to Add and then OK. The
correct date is shown.
If I press Escape now the new date is correctly shown.
If I press Enter instead of Escape I get 31 shown and
a Ctrl Drop Down menu.
Somehow this differs from 2007 but that's fine as long
as it works.

Enter and Esc work the same way for me in both XL2003 and XL2007.

In case someone might misunderstand what I mean by "work the same way", let
me clarify....

I meant to say: Enter and Esc each behave in XL2010 as they each behave in
XL2003 and XL2007, contradicting Glenn's assertion that something changed in
XL2010.

But Enter and Esc behave differently from each other, as I went on to
describe.


I wrote:
IIRC, Enter is a short-cut for paste after copy. (I never
rely on it.) Since the cell with 31 is still the active
copy ("marching ants"), pressing Enter will copy it to the
selected cell(s).

This is exactly the behavior that Glenn stumbled upon in XL2010. My point
is: it behaves that way in XL2003 and XL2007 as well. Nothing changed.

(Hypothetically, there might be some option to disable that behavior of
Enter. If there is, I am not aware of it. But that might explain why Glenn
was unaware of it in past Excel versions.)


I wrote:
Pressing Esc simply "cancels" the active copy; it turns off the "marching
ants".

Again, this is the behavior that Glenn stumbled upon in XL2010. And again,
it behaves that way in XL2003 and XL2007 as well. This is the correct way
to cancel a copy operation.