Re: Opening .csv with excel: everything in one column

Tech-Archive recommends: Speed Up your PC by fixing your registry

Go into Windows Control Panel, Regional and Language Options, Customize,
Numbers and make sure the List Separator character is a comma.

--
Jim
"Eline Jonkers" <ejonkers@xxxxxxxxx> wrote in message
news:1182352422.875725.47720@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
| Hi,
|
| When I open a .csv file in excel, everything opens in one column. Of
| course I can use 'Data->Text to Columns' to put everything in seperate
| cells, but for my work I have to do this a million times and it is
| getting really annoying. Excel should be able to open .csv files and
| put everything automatically in the right cells instead of in one
| column.
|
| My collegaes do not have this problem, the same .csv files
| automatically open in the right way in excel on their computers.
| I tried a simple file, one that only contains:
| a,b,c,d
| and excel put this in one column! I really want to find out why excel
| does not do this putting in the cells automatically on my computer.
| I could not find the answer anywhere. Maybe someone can help me??
|
| Eline
|


.

Relevant Pages

  • Re: Access and Excel
    ... The workbook has protected sheets, with protected cells ... open book, turn off protection, read the data, turn protection ... Don't use Excel automation, ... > If I open the workbook in Excel and the workbook is not shared, it opens ...
    (microsoft.public.office.developer.vba)
  • Re: Why are my Add-In formulas recalculating everytime I open a wo
    ... So it apparently does not see those cells as changed. ... When I open up a workbook that contains calls to my UDF, ... The only reason I can imagine for this behaviour is that Excel does not know ... it opens fine even though I don't ...
    (microsoft.public.excel.programming)
  • Re: help to open excel file
    ... it opens all the cells are blank, in properties it does show that there is ... Excel file open in OpenOffice? ... Can also mean you have negative times in the cells. ... get the message "the file is not in a recognisable format" I have only ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Excel loading CSV problem
    ... We were surprised by the change in functionality after the upgrade. ... Excel has treated 1-31 and 1-23 as dates for as long as I can remember through ... TIW opens for me in 2003 when I open a *.csv file renamed to *.txt ... You might try changing the extension on the CSV files to *.TXT ...
    (microsoft.public.excel)
  • Re: Why are my Add-In formulas recalculating everytime I open a wo
    ... of the information from the cells that contain my formula and then make one ... The Excel Calculation Site ... When I open up a workbook that contains calls to my UDF, ... it opens fine even though I don't ...
    (microsoft.public.excel.programming)