Importing HTML List

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

Hi,

I'm importing a web page into Excel. The web page contains a table of
file info such as PRIMARY | SECONDARY | FILE NO.

I import all 3 columns OK, apart from some instances of file number.

At times, the file no. translates incorrectly to a date e.g 10/3 ends
up incorrectly as 10-Mar-1900 rather than remaining as 10/3

Has anyone any clues on how I can convert these instances back to a
real "file number".

Formatting as General or Text doesn't seem to do the trick.

Tks, Kay
 
You may find the easiest(?) method is to copy that data and paste into Notepad.
Then save that file as something.txt.

Then open something.txt in excel. You'll be able to specify how each field
should be treated (date or text or general...).
 
You must log in or register to reply here.

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

correct total column in filtered list 1
correct total column in flitered list 4
Turning off "intelligent" date-formatting... how? 2
Stopping excel from converting numbers into dates on import 10
Cut and paste from web pages, emails, is breaking up text into multipleExcel cells 3
Importing into predefined fields 5
import and saving data 1
wrong year 5

Back
Top