View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.misc
duane duane is offline
external usenet poster
 
Posts: 64
Default 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.