I had the same issue but sorted it today.
rather than cut and paste the web data, I created a web query, and there is
an option that works.
from excel
dataimport external datanew web query
there is an button marked options in the top right of the dialogue window
that provides an option to disable date recognition.
The web query thing is good too.
wahoo!
S.
"jetted" wrote:
Another solution:
Format the cell(s) as Text prior to entering data into them and
Excel will leave them alone.
Thanks
Denis
--
jetted
------------------------------------------------------------------------
jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532
View this thread: http://www.excelforum.com/showthread...hreadid=560989