Keep IDs as is with no date conversion

  • Thread starter Thread starter Ellen
  • Start date Start date
E

Ellen

Hello,
I have a web page that I want to convert to an Excel pread
sheet. In it there is a table that contains ID#s. An
example of one of the ID#s is 03-2254, which Excel
converts to "Mar-54". Is there a way for me to keep the
ID#s as is and not have them converted into some sort of a
date?

Thank you in advance,
Ellen
 
Use the Text Import wizard and choose Text as the column format in the
third pane.
 
I've tried the import wizard for my HTML document and it
still gives me the date conversion thing. Does my
document need to be a text file to work?
 
Hit send too early -

I didn't glom onto the fact that you were trying to import the html file
directly.

Instead, I'd recommend a web query...
 
Thanks for your help. I was able to isolate those
particular -s and change them into |s so the date
conversion didn't happen. Once I got it into Access I
changed the |s back to -s
-----Original Message-----
Hit send too early -

I didn't glom onto the fact that you were trying to import the html file
directly.

Instead, I'd recommend a web query...
Click to expand...
 
Back
Top