View Single Post
  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Ron,

Try changing the file's extension to txt. That should invoke the Text
Import Wizard, which will let you specify your delimiter.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Ron P" <Ron wrote in message
...
Regardless of the list separator value in regional settings, when
double-clicking the csv file, Excel 97 opens the file using "," as the
delimiter. Otherwise, when opening the file via FileOpen in Excel or
using
open with...Excel, the regional settings are not ignored. Is there a
reason
for this? Thanks in advance.