View Single Post
  #2   Report Post  
Damon Longworth
 
Posts: n/a
Default

A workaround is to rename the file with a TXT extension. This will force the
input wizard to open and you will be able to define the delimiter.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"EJO" wrote in message
...
By company standard, I'm using an US edition of Windows XP pro. (sp2 all
patches installed.) and Office 2003 SP1, again us edition. I work in
holland
so I would prefer using the dutch regional settings in my control panel.

What frustates me:
When I'm using US Regional settings in control panel, changing list
seperator actually works and influences the way Excel opens CVS files.
When i'm Dutch regional settings, changing the list seperator char does
not
influence the way Excel opnens CVS files, in effect we can't work with csv
files at all.

Please correct this as soon as you can, or provide some feedback to users
like me that can not explain this.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc