okay. I checked that earlier but it was already set to comma. this is
getting very frustrating. I am sure it is something easy ....but
what???????????

"Dave Peterson" wrote:

Windows can be customized for different regions in the planet. The List
separator is one of those things that can be changed.

Close excel
windows start button|settings|control panel|Regional and language options

Click the customize button
Numbers Tab
List separator

In Europe, the list separator is usually the semicolon (;). In the USA, it's
usually the comma (,).

But if the user's regional settings don't match what the data contains, you can
see the problem that you described. (In fact, I've never seen another cause for
the problem you describe.)





marshall wrote:

what do you mean by list separator?
It just automatically opens in excel
"Dave Peterson" wrote:

On the troublesome pcs...

Did you check the list separator there (each pc could be different)?

Do you save the .csv file to the harddrive first, then double click on it to
open it in excel--or is it something you just click on (on a web page) and excel
opens it automatically?

If you don't save it locally first, what happens if you do save it locally.





marshall wrote:

i have a report I pull from an insurance company that says to download in csv.
when I am on one of my computers it downloads and separates into columns
correctl. when I go to my newer PC's it downloads but is just line after
line of info
that should be separated inot columns not just by comma's.
If I save the download from the first PC (that does it correctly) The newer
pc's read it fine and in the correct columns. This is real distressing
because it won't open on any of my 100 newer pc's correctly.

"Dave Peterson" wrote:

I don't have any other guess.

Maybe you can explain what you're doing in more detail. I just guessed that you
were doubleclicking on the filename in windows explorer.

marshall wrote:

I just checked it and it is a comma
if you can think of anything else it would be great

"Dave Peterson" wrote:

Make sure your windows list separator matches the field separator in your CSV
file (a comma in both spots).

Close excel
windows start button|settings|control panel|Regional and language options

Click the customize button
Numbers Tab
List separator

Make sure it's a comma.

marshall wrote:

I have a .csv file that is supposed to be separated at the comma's into
columns. How do I get the comma delimited feature to work?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson