Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I think your current selecion is just a cell in cell A1, before downloading. Select all columns by clicking the left corner - Above row 1 and left of column A - and then try downloading again. This will display all the data as stored in the CSV file. Note: Although the source file may be delimited, you are just specifying a single cell as selection for importing data, therefore, Microsoft Excel assumes that you want to import all your data only into that particular cell. Challa Prabhu "Bill" wrote: This used to work before but now whenever I import a .csv file (I've tried each one that used to work before) entire records are being put into each column variable but the commas are still there. There must be a setting for this (looks like it doesn't recognize the comma any more) but darned if I can find it. I went into control panel and Regional/Laguages-- Customize and it already said that the separator char was a comma... Anyplace else I can check? thanks, Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing CSV files | Excel Discussion (Misc queries) | |||
Importing txt files one character per column/row. | Excel Discussion (Misc queries) | |||
Importing files | Excel Discussion (Misc queries) | |||
Importing CSV files | Excel Discussion (Misc queries) | |||
How do I record a macro which should work on multiple files ? | Excel Discussion (Misc queries) |