Openig CSV file format with Excel in Office 2007

J

jmarc

Office 2007 has just been installed
at the office, replacing Office 97.

The new Excel does not open existing
CSV files in the organisation, the same way
the Excel in Office 97 did before!

Each text line of CSV file is not anymore
parsed into differents spreadsheet cells
according to the coma (",") caracter. All the
text line is put into the first cell of the row...

As the new Excel's Help proposal, I reconfigure
the "list separator" caracter in the PC control
panel "Regional and Language Options", but
with no changes when opening CSV files...

I anyone know where to configure defaults
opening values for CSV file, or is not anymore
supported by latests Excel versions?

jmarc...
 
G

Guest

Hi. I don't know how to slove your problem, but I do use CS files on 2007,
and the cells work out fine.
Must be a setting somewhere, sorry I cant tell you :( g.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 unites csv file row contents in a column A with squares 1
CSV File Opening Conversion Issue 1
change csv list separator in excel 2007 Dutch version 1
CSV->Excel Data Problem 1
csv file with special separator 6
excel 2007 csv gibberish 1
*.csv format change if .xlt save as .csv in Excel 2007 1
Number in text format in CSV file 3

Top