View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default how do I get the comma delimited feature to work in excel

I don't have any other guess.

Maybe you can explain what you're doing in more detail. I just guessed that you
were doubleclicking on the filename in windows explorer.

marshall wrote:

I just checked it and it is a comma
if you can think of anything else it would be great

"Dave Peterson" wrote:

Make sure your windows list separator matches the field separator in your CSV
file (a comma in both spots).

Close excel
windows start button|settings|control panel|Regional and language options

Click the customize button
Numbers Tab
List separator

Make sure it's a comma.

marshall wrote:

I have a .csv file that is supposed to be separated at the comma's into
columns. How do I get the comma delimited feature to work?


--

Dave Peterson


--

Dave Peterson