csv format is wrong in Denmark

  • Thread starter Thread starter toarhansen
  • Start date Start date
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?
 
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
 
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
 
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:
 
Back
Top