If you rename the file to .txt instead of .csv then start Excel and
use File | Open, then Excel will automatically start the Text Import
Wizard. In the 3rd panel of this you can specify which fields you want
to import as text, so that Excel will not change them - good for
preserving leading zeros as well as avoiding conversions to dates.

Hope this helps.

Pete

On Jun 19, 1:21*pm, Mila wrote:
I have got CSV file where some values look like date but they aren't.
The value is stuff number e.g. "1.05" and I don't want convert it into "1..V"
How to disable automatic conversion when CSV is open by double click?

I use excel 2003 or 2007
Thanks