csv values

N

Nuno

Hi,

I'm experiencing a weird behaveour by excel: when i double-click a csv file
it opens excel (as it should) but, instead of appearing the import text
dialog box, or importing directly into a new excel sheet, it opens all the
file in just one column (with each row correctly defined, but with just one
column which have allthe information eith commas like ",,,,Country,,,,,",
etc.). The only way to make it import the file is to go to data>import>....
(which is quite borring and time consuming when we are opening several files,
which is the case)
I believe I'v already seen excel importing directly csv files, and maybe
I've changed a setting without knowing. Can anyone help?

Cheers,

Nuno
 
N

Nuno

That's a way of dealing with the problem, but I've tried to open the same csv
file in Office 2000, and it opened directly (no wizard) and with no
mistakes... Excel 2003 should be able to do then same

"Frank Kabel" escreveu:
 
F

Frank Kabel

Hi
have you checked that both systems have the same regional settings for
the delimiter?
 
N

Nuno

Hi,

How can I know this? The computer that is giving me problems is with
Portuguese settings. The other one is with english settings.



"Frank Kabel" escreveu:
 
F

Frank Kabel

Hi
and here is the problem :)
The Portugese Windows settings probably use the semicolon as delimter.
Goto your Windows regional settings:
'Start -> Settings - Control panel - Regional settings' and change the
delimter to a coma or rename the file to a *.txt file
 
N

Nuno

thanks frank!! I've changed the regional setting ans now evereything goes
just fine!Do you know any way of circumvent this problem, i.e., using the
(for ex.) portuguese settings and open these files?

"Frank Kabel" escreveu:
 
Top