The "Text" formatting of Excel 2010 has the following description:

The text is displayed exactly as entered.



However, that's simply not true. Whenever I past stuff into Excel, Excel turns the text into a date format (e.g. 1/2 becomes Jan-1). Furthermore, zeros at the end of numbers are cut off if the cells aren't long enough (e.g. 1.100 becomes 1.1). Turning the text back into "Text" format is not solution. Pre-formatting all cells as "Text" has no effect.

If have literally spend an hour searching for a solution and couldn't find one. The best thing I found is adding an apostrophe in front every "date", but this creates so much additional work that I don't consider it to be a solution.

Can anybody help?