Problem opening CSV file....

[Mangler]

When I open a CSV file in excel 2000 it is not displaying properly.
The data shows up, but is not separated into different columns where
the "," is like so :

test,test,test,test

However when I open the same file in excel 2007 is displays
perfectly :

test test test test


Is there something I need to do to get the data to show correctly in
2000?

 

[Don Guillett]

I don't have 2000 but try changing the file extension to .txt

 

[Mangler]

I don't have 2000 but try changing the file extension to .txt

--
Don Guillett
Microsoft MVP Excel
SalesAid Software







- Show quoted text -

Figured it out, turns out it is a known problem in XP. Just deleted
the csv file type and opened the file then selected excel when asked
what to open it with. The file is no longer associated with IE and
works great.

 

[Steve]

I don't have 2000 but try changing the file extension to .txt

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
message







- Show quoted text -

Figured it out, turns out it is a known problem in XP. Just deleted
the csv file type and opened the file then selected excel when asked
what to open it with. The file is no longer associated with IE and
works great.


Do you understand that CSV is an acronym for Comma Separated Values?
Opening the file with a word processor, notepad, wordpad or any other
document handler will produce the results you got because that is the
actual contents of the file.

Excel recognizes the CSV format and places each field of data in its
own separate column.

--
Steve Spence
Independent AMSOIL Dealer
AMSOIL - The "Once A Year" Oil Change
Unemployed Car Guy - Trying To Earn A Living
35 Years of G.M. Parts Experience
AutoCAD R14 Certified - 2D & 3D (ACIS solids)
URL: http://synthetic-oil-tech.com/1690163
Email: (e-mail address removed)

 

[Mangler]

Figured it out, turns out it is a known problem in XP.   Just deleted
the csv file type and opened the file then selected excel when asked
what to open it with.  The file is no longer associated with IE and
works great.

Do you understand that CSV is an acronym for Comma Separated Values?
Opening the file with a word processor, notepad, wordpad or any other
document handler will produce the results you got because that is the
actual contents of the file.

Excel recognizes the CSV format and places each field of data in its
own separate column.

--
Steve Spence
Independent AMSOIL Dealer
AMSOIL - The "Once A Year" Oil Change
Unemployed Car Guy - Trying To Earn A Living
35 Years of G.M. Parts Experience
AutoCAD R14 Certified - 2D & 3D (ACIS solids)
URL:http://synthetic-oil-tech.com/1690163
Email: (e-mail address removed)- Hide quoted text -

- Show quoted text -

I am very familiar with what a CSV file is and I was opening the file
with excel, as I said I after researching I found it was a common
problem in XP and very well documented too.

 

[Steve]

Figured it out, turns out it is a known problem in XP. Just deleted

the csv file type and opened the file then selected excel when asked
what to open it with. The file is no longer associated with IE and
works great.

Do you understand that CSV is an acronym for Comma Separated Values?
Opening the file with a word processor, notepad, wordpad or any
other
document handler will produce the results you got because that is
the
actual contents of the file.

Excel recognizes the CSV format and places each field of data in its
own separate column.

--
Steve Spence
Independent AMSOIL Dealer
AMSOIL - The "Once A Year" Oil Change
Unemployed Car Guy - Trying To Earn A Living
35 Years of G.M. Parts Experience
AutoCAD R14 Certified - 2D & 3D (ACIS solids)
URL:http://synthetic-oil-tech.com/1690163
Email: (e-mail address removed)- Hide quoted text -

- Show quoted text -

I am very familiar with what a CSV file is and I was opening the file
with excel, as I said I after researching I found it was a common
problem in XP and very well documented too.



OK... it's just that I use Windows XP with Excel 2003 and have never
seen the problem. It must be an issue with Excel 2007 only. Sorry
for the intrusion.

--
Steve Spence
Independent AMSOIL Dealer
AMSOIL - The "Once A Year" Oil Change
Unemployed Car Guy - Trying To Earn A Living
35 Years of G.M. Parts Experience
AutoCAD R14 Certified - 2D & 3D (ACIS solids)
URL: http://synthetic-oil-tech.com/1690163
Email: (e-mail address removed)

 

[Mangler]

I am very familiar with what a CSV file is and I was opening the file
with excel, as I said I after researching I found it was a common
problem in XP and very well documented too.

OK... it's just that I use Windows XP with Excel 2003 and have never
seen the problem.  It must be an issue with Excel 2007 only.  Sorry
for the intrusion.

--
Steve Spence
Independent AMSOIL Dealer
AMSOIL - The "Once A Year" Oil Change
Unemployed Car Guy - Trying To Earn A Living
35 Years of G.M. Parts Experience
AutoCAD R14 Certified - 2D & 3D (ACIS solids)
URL:http://synthetic-oil-tech.com/1690163
Email: (e-mail address removed)- Hide quoted text -

- Show quoted text -

No problems, Its a 2000 thing though, 2007 works great.