View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson
 
Posts: n/a
Default csv file opens in a single column

What do you have for your windows list separator?

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

Click the customize button
Numbers Tab
List separator

Make sure it matches your data.

Alternatively, you could always select that column and do data|text to columns.
Choose delimited by.

Thijs wrote:

I have several pc's here but only on one of them the csv opens in a single
column.
On the other pc's data is parsed into multiple columns.
How can I get this done automaticly?


--

Dave Peterson