Comment Re:30 years and the same annoyances (Score 1) 119
One way to prevent Excel from automagically guessing how it should treat the pasted data is to set the destination's cells format to "Text" before pasting (rather than the default "General"). Then, after pasting the data, some manual formatting is necessary, but at least you won't get unwanted roundings, nonsensical string-to-date conversions, scientific notations, etc.