Hi,
I have a standard CSV file which when opened Excel (2003 SP3) automatically
uses the spaces as a delimiter rather then the commas. How do I ensure Excel
automatically opens CSV files and used commas as a default rather then spaces
as a delimiter. I have Excel 2007 which reads the file correctly.
Cheers

The List Separator character designated under Windows Control Panel,
Regional Settings, Customize, Numbers controls Excel. When I changed mine
to a space a CSV file created in Excel 2003 used a space as the delimiter.
And on importing it ignored commas and parsed on spaces. So you might check
your Regional Settings.

--
Jim
"Andy Dale" <Andy wrote in message
...
| Hi,
| I have a standard CSV file which when opened Excel (2003 SP3)
automatically
| uses the spaces as a delimiter rather then the commas. How do I ensure
Excel
| automatically opens CSV files and used commas as a default rather then
spaces
| as a delimiter. I have Excel 2007 which reads the file correctly.
| Cheers
|

I have a similar problem and when I check my regional settings it has a comma
for list separater but when I open and csv in excel it picks up the tabs as
delimiter not the comma

"Jim Rech" wrote:

The List Separator character designated under Windows Control Panel,
Regional Settings, Customize, Numbers controls Excel. When I changed mine
to a space a CSV file created in Excel 2003 used a space as the delimiter.
And on importing it ignored commas and parsed on spaces. So you might check
your Regional Settings.

--
Jim
"Andy Dale" <Andy wrote in message
...
| Hi,
| I have a standard CSV file which when opened Excel (2003 SP3)
automatically
| uses the spaces as a delimiter rather then the commas. How do I ensure
Excel
| automatically opens CSV files and used commas as a default rather then
spaces
| as a delimiter. I have Excel 2007 which reads the file correctly.
| Cheers
|