Re: Excel loading CSV problem

See in-line........

On Fri, 02 Mar 2007 12:23:20 -0800, ewdtang <e_tang@xxxxxxxxxxxxxxx> wrote:

Hello

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

Excel has treated 1-31 and 1-23 as dates for as long as I can remember through
about 4 or 5 versions. If your previous version did not then something else was
preventing the change to a date funtion.


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.

TIW opens for me in 2003 when I open a *.csv file renamed to *.txt

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

Yes

Well it does involve less steps that using Data Import.

Again............yes


Is there any way to change the default cell type to TEXT instead of
GENERAL?
Not that I know of. When d-clicking to open a CSV file, it opens in the
deafault Excel workbook.

I know of no way to get it to open in a customized workbook template.


Gord


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.




.

Relevant Pages

  • Re: Opening .csv with excel: everything in one column
    ... | When I open a .csv file in excel, everything opens in one column. ... | cells, but for my work I have to do this a million times and it is ... | My collegaes do not have this problem, the same .csv files ...
    (microsoft.public.excel)
  • Opening .csv with excel: everything in one column
    ... When I open a .csv file in excel, everything opens in one column. ... cells, but for my work I have to do this a million times and it is ... My collegaes do not have this problem, the same .csv files ...
    (microsoft.public.excel)
  • XP SP2 - CSV files now appear in the browser instead of download
    ... We have a web application that outputs csv files (data to be loaded into ... them in excel. ... It now opens them up in the browser. ...
    (microsoft.public.windowsxp.help_and_support)
  • Missing Files, Access 2000
    ... Am trying to download .csv files from I'net. ... but it opens in Excel. ... I get a message "Missing ...
    (microsoft.public.access.externaldata)
  • Re: In-place activation of .CSV
    ... Hold the Shift key while you right click it. ... Choose open with and choose Excel, checking the box to always use this ... double click on a .csv in a file explorer it opens in Excel ... Excel with IE - and that's what I'd like to achieve with .csv files. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)