In the 3rd panel of the Wizard you can select each column in turn (it
highlights) and then select the column type from the list on the right
- it defaults to General (which is fine for numbers and "normal"
text), but you can also choose Text and Date formats (or you can
choose to skip the column). I don't think you can choose more than one
column at a time.

If you want to speed things up you can record a macro while you import
the data once so that it will have all those settings, and then re-use
the macro for subsequent imports. If you plan it carefully, you can
have the macro in a master file (which never gets changed) and this
opens the file and parses it how you would like it to be.

Hope this helps.

Pete

On Jun 19, 4:24*pm, Mila wrote:
Pete,
How to quickly select all column and define as a Text in the Text Import
Wizard.
I need see all column without any modification in Excell.

Thanks
Mila



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- Hide quoted text -

- Show quoted text -