P
ptp24
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
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