I am facing a problem with 'cut & paste' data. Say I am copying Kobe Bryan's 02-03 season game log (http://sports.espn.go.com/nba/…d=3118&sYear=2002&sType=2) and pasting them onto Excel spreadsheet. You will notice that under the columns FG, 3P and FT (where the information is stored as X-X) the pasted numbers automatically get converted to dates. Now obviously I do not want them to be converted to dates. Is there any way I can do to retain the original data in X-X form? The problem exists no matter I paste the data as HTML, Unicode or text.
Many thanks in advance!