M
Martha
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
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