By the way, I tested the vlookup and it worked perfectly!!! Thank you. Martha

"Shane Devenshire" wrote:

Hi,

When you come throught the import wizard, you can select the column of
concern and click the Text option.

If that doesn't work you can use a formula against the 41002 cell

=TEXT(C1,"MMMDD")

In fact you can write a formula such as

=VLOOKUP(TEXT(C1,"MMMDD"),G1:H100,2,FALSE)


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Martha" wrote:

I have a file that associates codes that look like dates (OCT26 for example)
with a Saints Day. When I export to excel via .csv, it looks like 26-Oct, and
if I then pull the cell over into another worksheet, I get the number date
code 40112. The column is defined as TEXT. I need to compare the codes to
the table via VLOOKUP, so I can disply the description in the report. Is
there anyway to tell Excel not to try to make this code a date? (I did try
the ' suggestion, but it doesn't work in this case).
Martha