View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
sprior sprior is offline
external usenet poster
 
Posts: 1
Default pasting data from a website changes text to date

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