Keep IDs as is with no date conversion

[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

 

[JE McGimpsey]

Use the Text Import wizard and choose Text as the column format in the
third pane.

 

[Ellen]

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?

 

[JE McGimpsey]

Yes.

 

[JE McGimpsey]

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...

 

[Ellen]

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...