Re: Excel loading CSV problem

Hello

We were surprised by the change in functionality after the upgrade.

When I attempt your suggestion, I do not get the Text Import Wizard,
instead the CSV data is dumped into Column A as a single column.

(which will mean I would use the Text-to-column tool to bring up the Text
Import Wizard after selecting Column A)

Well it does involve less steps that using Data Import.


Is there any way to change the default cell type to TEXT instead of
GENERAL?


Thanks.

Gord Dibben <gorddibbATshawDOTca> wrote:
I am surprised to hear your previous version of Excel did not produce the same
results when opening the CSV files.

You might try changing the extension on the CSV files to *.TXT

When opened, these will pop up the Text Import Wizard where, in the third step
you can designate Column Data Format as Text.


Gord Dibben MS Excel MVP

On Fri, 02 Mar 2007 11:28:18 -0800, ewdtang <e_tang@xxxxxxxxxxxxxxx> wrote:


My workplace just upgraded the software on our computers, now my coworkers
and I have trouble loading CSV files. Using Office 11, (I believe we used
to use Office 10) when we load a column of data that is formatted #-#,
where
a-b
a : 1-31
b : 1-12
this becomes a day-month date
a : 1-12
b : 0,31+
this becomes a month-year date

We open CSV files (autogenerated by other software) by double clicking on
them.

Is there any way to turn off this behaviour and treat it as text? The
previous setup we had, MS Excel treated this as text, and there was no
autoconversion on load problem.

Is the only option to import the data? That's a considerably longer
process than what we do now.


The column is an internal part identification, and it'd be hard to change
it's representational format.

Thanks.




.