I'm working with the following source: http://www.usatt.net/league/singles/match_records.asp
From that URL you will probably need to select a league from the drop-down and display its results.
This displays a table which includes a column for Won/Lost. I'm selecting this table in the web browser and copy/pasting into Excel. Everything is coming into its own cell nicely, but the Won/Lost column is getting converted to a date for some reason. For example, it sees 4 - 2 as April 2nd.
I've tried paste as text, paste as unicode, paste as html, but each do the same thing. After the paste I tried to format the cells back to a "general" format but then it ends up with some very large number like 42587. No idea where that comes from.
How can I get that data to paste in as-is and not convert anything? Any information on this would be greatly appreciated. Thanks!