opening csv file in regular excel format
 

i am using office 2003. i used to download csv files and open in regular excel formats...due to some problem i reinstalled windows xp and office 2003...now my csv files open with all values separated by commas and not as before...

sould anyone highlight how to download csv files automatically in excel formats withouts commas?

suresh babu,chennai,india

opening csv file in regular excel format
 

If the data has commas between each field and you want each field in a separate
column, you'll have to make sure that your windows list separator is a comma.
(Many places, this list separator is a semicolon.)

windows control panel
Regional and Language Options
Regional options tab
click the Customize button
Numbers Tab
change that list separator character.

Remember that this is a windows setting. It will affect other programs, too.
(You may want to change it back when you're done importing the data.)





sureshbabussb wrote:

i am using office 2003. i used to download csv files and open in regular
excel formats...due to some problem i reinstalled windows xp and office
2003...now my csv files open with all values separated by commas and
not as before...

sould anyone highlight how to download csv files automatically in excel
formats withouts commas?

suresh babu,chennai,india

--
sureshbabussb

--

Dave Peterson