View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson
 
Posts: n/a
Default How do I download and open a CSV file in Excel 2000?

I'd look at the windows setting that controls the list separator.

windows start button|settings|control panel|Regional settings applet
(or regional and language options)

Click the customize button
Numbers Tab
List separator

Make sure it matches the separator in the data (a comma).



Doug P wrote:

From a research website I use, there is a link to download a CSV file into
Excel. On my other computer, when I run this link, the CSV file opens with
all the columns populated properly. That is, all the information in the
proper columns. For some reason, on this computer, when I run the same
download, I get a spreadsheet with all the information in the column A.

What setting changes do I need to make for this spreadsheet to open
properly, with the values separated at each comma?


--

Dave Peterson