csv format is wrong in Denmark

T

toarhansen

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?
 
J

Jacob Skaria

This is something to be done with the Windows setting. Start>Settings>Control
Panel>Regional and Language Options>From '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
 
P

Per Jessen

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
 
S

Stefi

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top