Turn off automatic date formatting
Format the cells as Text.
You can do this by doing a right click on a cell or an entire column. Then
choose fomat cells. In the Category choose Text
Should work
"jwt" wrote:
I'm pasting data into an Excel spreadsheet which is formatted as W-L-T, i.e.
1-0-2. Excel very handily insists that I'm trying to paste in a date, even
though most of the values clearly aren't valid dates (which values Excel
leaves alone). Other than writing a formula to figure out where Excel has
outsmarted itself, is there a way to turn this "feature" off?
|