Excel automatically recognizes any file with a "CSV" extension as one of it's
own, you do not get any iport options. A work around might be:

Rename your file exported from Access with a "txt" extension. Then open that
file with Excel. You will then have an opportunity to define the format of
each field as General, Text, Date, number and so forth. Simply define the
problem field as text.

HTH

"Jon Stenning" wrote:

I know that you can stop it when entering data by using a ' before the data,
but I have exported data as a csv from Access and want to read it in Excel;
yet every time I open the csv it converts the available years (i.e. it
ignores 00/01, but converts 01/02, 02/03 etc) to dates. Is there a box
somewhere in 'options' that I have to tick/untick?

Thanks.