Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
Try to check if in Windows Control panel/International settings/Custom
settings List separator are set different than on the other machines! Regards, Stefi €žDavid€ť ezt Ă*rta: I have a user that when they try to open a CSV file from the desktop or any other location the file does not open correctly. When the file is opened on other machines using Excel it opens correctly. What seems to be happening is in column A we are getting the first 14 characters of the line and in column B we are getting the next 10 characters and in column C we are getting the rest of the line. The system is not parsing the record out because we are still seeing the quotes and commas in the columns. When we run the text to columns wizard on column C it parses out the record correctly. I am not sure what the issue could be that is opening the file in a "fixed with" method ... because this is happening it seems on all CSV files. The user tried to reinstall Excel and I personally did a repair on Excel and the issue is still present. Any ideas? David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening File Issue? | Excel Discussion (Misc queries) | |||
How to avoide data conversion when opening a text file? | Excel Discussion (Misc queries) | |||
Opening Excel file issue? | Excel Discussion (Misc queries) | |||
File Opening issue | Excel Worksheet Functions | |||
File conversion-text encoding issue | Excel Discussion (Misc queries) |