Rename your .csv as .txt, then the text import wizard allows you to specify
the format of each column at the import stage.
With a file named .csv, Excel always thinks it knows best.
--
David Biddulph

"Jon Stenning" <Jon wrote in message
...
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.