Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel displaying csv wrong
Hello all,
I have two files, both with an extension of .csv. One file is retrieved from a website and the other is generated by an application (which initially retrieves it from that same website). When I look at these two files in notepad, they are visually identical, however, Excel does not display them in the same way. When I double click on the file from the webpage it opens in Excel and the columns are all separated properly using the commas as delimiters, but when I double click on the file from the application all the data for each row in the report is displayed in the first column and the commas are not recognized as delimiters. Does anyone know why this would be happening and how I might be able to fix it? I'm using Excel 2003. I've found similar questions online, but I haven't been able to find a resolution. Several posting suggest checking the 'List separator' value, which is set to a comma on my machine. Any and all suggestions would be appreciated. Thanks, Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's wrong with my formula? Excel 2000. | Excel Worksheet Functions | |||
Copy formulas displaying wrong value | Excel Discussion (Misc queries) | |||
Excel is totaling wrong | Excel Worksheet Functions | |||
excel totaling wrong | Excel Discussion (Misc queries) | |||
YYYY format displaying wrong date | Excel Discussion (Misc queries) |