When I make csv file from excel 2007, then I do not get a comma-separated
file. The cells are separated with a semicolon and the the normal dot in
numbers is a comma. This is the case when you live in Denmark.

The problem with the "Danish" excel csv format is that we can not export it
to what ever we want. If I want to use it in Microsoft Visual Studio Team
System, for a unit test, then it does understand the format.

Is it possible in Office to save in correct cvs format?

This is something to be done with the Windows setting. StartSettingsControl
PanelRegional and Language OptionsFrom 'Regional Options' tab click
Customize and change the 'List separator' from semi-colon to Comma and also
check out 'Decimal symbol' and digit grouping symbol specified.

Now Restart Excel and try saving as .csv format

--
Jacob


"toarhansen" wrote:

When I make csv file from excel 2007, then I do not get a comma-separated
file. The cells are separated with a semicolon and the the normal dot in
numbers is a comma. This is the case when you live in Denmark.

The problem with the "Danish" excel csv format is that we can not export it
to what ever we want. If I want to use it in Microsoft Visual Studio Team
System, for a unit test, then it does understand the format.

Is it possible in Office to save in correct cvs format?

Hi

Another option, save the CSV file without changing any settings, then open
the .csv file in Word or another text editor, and use Find/Replace, to
replace comma with dot, then replace semicolon with comma. Save the file.

Hopes this helps.
....
Per

"Jacob Skaria" skrev i meddelelsen
...
This is something to be done with the Windows setting.
StartSettingsControl
PanelRegional and Language OptionsFrom 'Regional Options' tab click
Customize and change the 'List separator' from semi-colon to Comma and
also
check out 'Decimal symbol' and digit grouping symbol specified.

Now Restart Excel and try saving as .csv format

--
Jacob


"toarhansen" wrote:

When I make csv file from excel 2007, then I do not get a comma-separated
file. The cells are separated with a semicolon and the the normal dot in
numbers is a comma. This is the case when you live in Denmark.

The problem with the "Danish" excel csv format is that we can not export
it
to what ever we want. If I want to use it in Microsoft Visual Studio Team
System, for a unit test, then it does understand the format.

Is it possible in Office to save in correct cvs format?

It's interesting, I wanted to produce a semicolon-separated text file but my
Hungarian 2003 version produced comma-separated ones not taking into account
Windows Regional settings.

I found a general solution to problems of this kind on this site:
http://www.cpearson.com/Excel/ImpText.aspx
Maybe you can make use of it, too.

--
Regards!
Stefi



€žtoarhansen€� ezt Ã*rta:

When I make csv file from excel 2007, then I do not get a comma-separated
file. The cells are separated with a semicolon and the the normal dot in
numbers is a comma. This is the case when you live in Denmark.

The problem with the "Danish" excel csv format is that we can not export it
to what ever we want. If I want to use it in Microsoft Visual Studio Team
System, for a unit test, then it does understand the format.

Is it possible in Office to save in correct cvs format?