Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
want to download csv file from website and need to open in Excel. | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Microsoft Excel in Microsoft works - how to open | Excel Discussion (Misc queries) | |||
Excel startup switches | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |