[csforum] problems with commas

[E & A. Fraser, ArchEng]

I'm sure this is a common problem, but it has been many years since I last saw it. (Mike M are you still around?)   My Windows app writes data to a CSV file so that Excel can be used to analyse it further.   My client has a customer in Sweden who is unable to load the CSV files correctly - all data ends up in one column. I assume that this is because on the customer's PC it is expecting an alternative character in place of the comma (ascii 0x2C), or maybe it expects a comma instead of the decimal point (ascii 0x2E) that is in some of the data fileds.   If my app needs to be altered to fix this then is there a Windows API that allows me to find out how various characters should be represented on the target PC? Or is there a better solution?   Thanks   Ewen Fraser ArchEng Designs Ltd