I am trying to copy data from the web. When I paste it in Excel, it is converting numbers with dashes such as 3-3 or 5-0 into date format. I've tried pasting it as text, and then using the 'text to columns' option but it still converts to date once I do it. I tried improting it as a new web query, but it won't import the table I want.
Any help would be greatly appreciated! Thanks in advance.
Pete
Bookmarks