Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jay Jay is offline
external usenet poster
 
Posts: 671
Default 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
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
What's wrong with my formula? Excel 2000. HWhite Excel Worksheet Functions 2 February 9th 07 04:08 AM
Copy formulas displaying wrong value gitlin Excel Discussion (Misc queries) 2 December 29th 06 04:40 AM
Excel is totaling wrong Daxy Excel Worksheet Functions 1 July 10th 06 07:38 PM
excel totaling wrong brian Excel Discussion (Misc queries) 5 May 12th 06 03:46 PM
YYYY format displaying wrong date Blaise Excel Discussion (Misc queries) 3 October 12th 05 02:28 AM


All times are GMT +1. The time now is 03:07 PM.

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

About Us

"It's about Microsoft Excel"