If I doubleclick on a csv it opens in Excel but all the data is in one column.
If I do the same on another pc the data is displayed correct.

Is this a setting and where can I change it?

MS Office 2000.

Jo

Excel sees any file with the extension *.csv as a native file and tries to
open it straight away. Once in Excel you could parse it using DataText to
columns

Alternatively, remove the extension or replace it with .txt and Excel will
launch the text import wizard

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Jo Segers" <Jo wrote in message
...
If I doubleclick on a csv it opens in Excel but all the data is in one
column.
If I do the same on another pc the data is displayed correct.

Is this a setting and where can I change it?

MS Office 2000.

Hi
you probably have different windows regional settings for your list
delimiter. One workaround (except changing the Windows regional settings).
Rename your file to *.txt and open this file with Excel. The text import
wizard should start and should allow you to choose a different delimter

--
Regards
Frank Kabel
Frankfurt, Germany

Jo Segers wrote:
If I doubleclick on a csv it opens in Excel but all the data is in
one column. If I do the same on another pc the data is displayed
correct.

Is this a setting and where can I change it?

MS Office 2000.

Thanks Nick,

But why does it open differently on one pc than on the other?

"Nick Hodge" wrote:

Jo

Excel sees any file with the extension *.csv as a native file and tries to
open it straight away. Once in Excel you could parse it using DataText to
columns

Alternatively, remove the extension or replace it with .txt and Excel will
launch the text import wizard

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

Jo

See Frank's reply re regional settings

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Jo Segers" <Jo wrote in message
...
Thanks Nick,

But why does it open differently on one pc than on the other?

"Nick Hodge" wrote:

Jo

Excel sees any file with the extension *.csv as a native file and tries
to
open it straight away. Once in Excel you could parse it using DataText
to
columns

Alternatively, remove the extension or replace it with .txt and Excel
will
launch the text import wizard

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

Hi
as stated: Different Windows regional settings. Goto the Windows start menu,
open the Control panel and check these settings

--
Regards
Frank Kabel
Frankfurt, Germany

Jo Segers wrote:
Thanks Nick,

But why does it open differently on one pc than on the other?

"Nick Hodge" wrote:

Jo

Excel sees any file with the extension *.csv as a native file and
tries to open it straight away. Once in Excel you could parse it
using DataText to columns

Alternatively, remove the extension or replace it with .txt and
Excel will launch the text import wizard

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

I'm not convinced by these answers. I have a similar issue, which I will
explain.

One of our web apps (intranet) creates a csv file and parses it to excel. On
SOME people's machines, this opens fine with all the data in seperate
columns. Other people's machines put it all in ONE column. I have checked
regional settings and they are all the same. The applications are the same,
and the file types appear to be the same also. Any further ideas about what
could resolve this?

"Frank Kabel" wrote:

Hi
you probably have different windows regional settings for your list
delimiter. One workaround (except changing the Windows regional settings).
Rename your file to *.txt and open this file with Excel. The text import
wizard should start and should allow you to choose a different delimter

--
Regards
Frank Kabel
Frankfurt, Germany

Jo Segers wrote:
If I doubleclick on a csv it opens in Excel but all the data is in
one column. If I do the same on another pc the data is displayed
correct.

Is this a setting and where can I change it?

MS Office 2000.

I would double check the list separator under the windows regional settings
applet one more time.

KeithMeister wrote:

I'm not convinced by these answers. I have a similar issue, which I will
explain.

One of our web apps (intranet) creates a csv file and parses it to excel. On
SOME people's machines, this opens fine with all the data in seperate
columns. Other people's machines put it all in ONE column. I have checked
regional settings and they are all the same. The applications are the same,
and the file types appear to be the same also. Any further ideas about what
could resolve this?

"Frank Kabel" wrote:

Hi
you probably have different windows regional settings for your list
delimiter. One workaround (except changing the Windows regional settings).
Rename your file to *.txt and open this file with Excel. The text import
wizard should start and should allow you to choose a different delimter

--
Regards
Frank Kabel
Frankfurt, Germany

Jo Segers wrote:
If I doubleclick on a csv it opens in Excel but all the data is in
one column. If I do the same on another pc the data is displayed
correct.

Is this a setting and where can I change it?

MS Office 2000.




--

Dave Peterson

I have quadruple checked these settings and they are the same. The machine
next to me that works is XP SP1 and I am SP2. One of the other people that it
works for is XP SP2 but has Office 2003. Any other suggestions?

"Dave Peterson" wrote:

I would double check the list separator under the windows regional settings
applet one more time.

KeithMeister wrote:

I'm not convinced by these answers. I have a similar issue, which I will
explain.

One of our web apps (intranet) creates a csv file and parses it to excel. On
SOME people's machines, this opens fine with all the data in seperate
columns. Other people's machines put it all in ONE column. I have checked
regional settings and they are all the same. The applications are the same,
and the file types appear to be the same also. Any further ideas about what
could resolve this?

"Frank Kabel" wrote:

Hi
you probably have different windows regional settings for your list
delimiter. One workaround (except changing the Windows regional settings).
Rename your file to *.txt and open this file with Excel. The text import
wizard should start and should allow you to choose a different delimter

--
Regards
Frank Kabel
Frankfurt, Germany

Jo Segers wrote:
If I doubleclick on a csv it opens in Excel but all the data is in
one column. If I do the same on another pc the data is displayed
correct.

Is this a setting and where can I change it?

MS Office 2000.




--

Dave Peterson

I don't have another guess.

KeithMeister wrote:

I have quadruple checked these settings and they are the same. The machine
next to me that works is XP SP1 and I am SP2. One of the other people that it
works for is XP SP2 but has Office 2003. Any other suggestions?

"Dave Peterson" wrote:

I would double check the list separator under the windows regional settings
applet one more time.

KeithMeister wrote:

I'm not convinced by these answers. I have a similar issue, which I will
explain.

One of our web apps (intranet) creates a csv file and parses it to excel. On
SOME people's machines, this opens fine with all the data in seperate
columns. Other people's machines put it all in ONE column. I have checked
regional settings and they are all the same. The applications are the same,
and the file types appear to be the same also. Any further ideas about what
could resolve this?

"Frank Kabel" wrote:

Hi
you probably have different windows regional settings for your list
delimiter. One workaround (except changing the Windows regional settings).
Rename your file to *.txt and open this file with Excel. The text import
wizard should start and should allow you to choose a different delimter

--
Regards
Frank Kabel
Frankfurt, Germany

Jo Segers wrote:
If I doubleclick on a csv it opens in Excel but all the data is in
one column. If I do the same on another pc the data is displayed
correct.

Is this a setting and where can I change it?

MS Office 2000.




--

Dave Peterson


--

Dave Peterson