View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default csv format is wrong in Denmark

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?