Urhixidur

If you search on "vince" you will find 6 posters who have a similar problem.

find "option to prevent Excel changing 1-2-3 to a date" and agree with the
suggestion.

--
Vince


"Urhixidur" wrote:

It is a ridiculous state of affaires when Excel does not allow a simple copy
and paste without screwing it up. Excel dates are very useful in some cases
and in others they are a pain.

Indeed. I found this thread (and *only* this thread) when I searched for «
Automatic data conversion when pasting », trying to solve a problem that
cropped up suddenly.

I have this fixed-format file that I grab (sending the .txt contents to the
clipboard through the .ContentsOnClipboard SendTo target, courtesy of the
PowerToys), and then a simple Excel macro pastes it in before parsing it into
columns. It used to paste into a one-column-by-many-lines cell block, but
suddenly Excel insists on parsing it out at paste time, without my consent.
Why the sudden change of behaviour? How to prevent it from occurring?