Highlight the column where the date is going, right click, format cells, go
to the number tab and choose the format you would like the date in.
"Saxman" wrote:
Is there any way within Excel whereby I can disable date recognition? I
often copy data from an HTML page and paste it into Excel. Even if I
select 'paste special'/'text', I still have problem with data like
10-12, and 5/6.
I can overcome this by importing data/new web query/options/disable date
recognition, but it appears to be a bit long-winded compared to copy/paste.
Thanks.
|