Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
Doug P
 
Posts: n/a
Default How do I download and open a CSV file in Excel 2000?

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?
  #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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
want to download csv file from website and need to open in Excel. Jeff Excel Discussion (Misc queries) 2 January 17th 06 05:35 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Microsoft Excel in Microsoft works - how to open R J Gavin Excel Discussion (Misc queries) 3 September 16th 05 08:29 PM
Excel startup switches Randy Excel Discussion (Misc queries) 9 June 14th 05 10:27 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


All times are GMT +1. The time now is 04:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"