View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Excel 2000 importing csv

You could try right-clicking on one of the .csv files then Open With -
click Choose Program at the bottom of the list, then check on "Always
use selected program to open this kind of file", then highlight Excel
from the list (or choose Browse if it is not displayed), then OK.

Hope this helps.

Pete

On Jul 25, 1:54 pm, maryj wrote:
We have a couple of users still using Win2K/Office 2K. There is a web based
application that exports data into Excel in a csv format. For these users,
all of the data gets dumped into Column A rather than separating. For users
on WinXP/Office 2003, we have gone into the Regional options and made sure
the List Separator option is set to comma. We tried this on the Win2K machine
but it did not resolve the problem. The users could go through the Text to
Columns wizard to separate, but this is something they will be doing daily
and it should separate automatically.

Any other ideas to try?
Thanks!
--
maryj