Re: Excel loading CSV problem

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: Problem with CSV file
    ... You should never reopen CSV files "just to check" them, ... This was done because the first sheet contained the maximum ... number of records Excel can handle. ... but the rest convert to exponent format. ...
    (microsoft.public.excel.misc)
  • Re: Code looping through files new line
    ... Why not let your excel code open the original CSV files, ... Otto and I have talking this morning and here are some clarifications about ... Dim fso As Object, fl As Object ...
    (microsoft.public.excel.programming)
  • Re: With excel 2003 could open .csv file but not in excel 2007.
    ... I didn't know that you were using code to open your .csv files. ... And even though re-registering excel won't help your code, ... Function RowCountYX(ReferenceCell As String, RowOffset As Integer, ColOffset ... Dim Blank As Boolean ...
    (microsoft.public.excel.programming)
  • Re: Creating a .csv file that will import to multiple worksheets
    ... I meant that if you can the output csv files in the format that Excel ...
    (microsoft.public.excel.programming)
  • Re: Linked .csv File Locking
    ... I have a daily automated job that creates multiple .csv files on a UNIX box, ... There are many users opening and linking to these files via Excel and MS ... multiple users of a read-only .csv file? ...
    (microsoft.public.access.security)