option to prevent Excel changing 1-2-3 to a date
I completely agree with the suggestion.
In my case, I have a block of data to paste (scraped from a table on the
internet), two columns of which are win-loss records (11-3, 10-4, etc.). Not
only are they displayed as dates, but the cell contents are converted to date
code so there is no hope of changing them back.
|