Import HTML data into Excel - data in "1-1" format translates to J

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been fighting this issue for sometime.

If I import HTML data that looks like "1-1" or "4-2" i would like it to
come across treated as text. Then I would take that column and split text to
columns so I could end up with column A/row 1 = to 4 and column B/row 1 = 2
(using the 4-2 example above).

Insteand I get a date conversion for any value that could vaguely look like
a date.

1-1 becomes Jan 1
4-2 becomce April 2

Any ideas how to shut off the automatic date processing?
 
Paul

If you are importing this via a web query (Data>Import external data>New web
query...), in the web page dialog (where you select the data you want),
select Options... and check 'disable date recognition'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to keep "1:1" as text 3
repeated conversion of data summarized into rows and columns 4
Import data csv file - tab delimited - and sort to column 3
How to group all data from 1 column into several columns 2
How To Combine Several Rows of Data into 1 Row of Data 3
How to group all data from 1 column into several columns (Redo) 2
Convert 3 columns into 1, as text. 2
paste data omiting blank values 1

Back
Top