View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default csv format is wrong in Denmark

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?