export decimal numbers to csv

How exactly are you exporting?

Choice of decimal separator and "list" separator (the character used to delimit .csv files) control how Excel chooses to create .csv files. These settings are in Windows Control Panel -- Region and Language settings. It looks like you currently have comma set as your decimal separator and semicolon as your list separator, and you want to have comma as both your decimal and your list separator. If that is the case, changing your list separator to comma should allow you to create the .csv files as you have described.

I don't know that we can make any suggestions without seeing the VBA code you are using. If I guess at the problem, you are probably not using enough quotation marks in your code. Since quotation marks are used to indicate string variables, in order to include quotation marks as part of a string, you must often nest the quotation marks within other quotation marks. For example:

Please Login or Register  to view this content.

When I execute this code, text1 contains the text string 11.12, where text2 contains the text string "11.12". I suspect that you need to do something similar with your VBA code -- nest the quotation marks within more quotation marks so that VBA will know to include a set of quotation in the string written to the .csv file.

How well do you understand this code?

The export string is created and stored in the variable wholeline in this loop:

Please Login or Register  to view this content.

Note the If then..else..end if block. This is the block that reads the cell value and stores the value in CellValue. Note how, in the first option where he tests for empty cells, how he use the Chr(34) function to return the double quote character, then uses the concatenate operator (&) to put two double quotes together and store them in CellValue. You should be able to do the same thing in the Else option to add double quotes around the Cells value. CellValue=chr(34)&cells(...).value&chr34&...