Get rid of thousands separator

Hi everyone. I am using VB10 to store my data to Excel. My problem is that I am trying to write my decimal number, which is stored in a String Array to Excel sheet. And my Excel doesn't store my number as decimal but as a whole number, which is separated by thousands separator. For example I have 3017,1002145 in my Array field, but when I am writing this value to excel I am getting 30,171,002,145

How can I solve this?

Thanks

Hi Ross, thanks for your reply. But this doesn't solve the problem. Looks like my thousands operator was already deactivated, but as I wrote, somehow, my numbers are transfered to Excel table with the thousands separation.

here some code, I am receiving data (hex numbers, but represented in integer), therefore I have to convert the number to hex, concatenate two hex part (two parts represents whole number, two another parts represents decimal part) convert to integer, divide by some factor, concatenate then the whole and decimal parts. Convert the final decimal number to string, store it into an array.

Please Login or Register  to view this content.

thanks for your tips, looks like I had to change the decimal definition in my excel. I had "," defiende before and had to change it to ".". Now it works fine.

Bye
Dennis