Having problems with data passed to excel!

[vanja]

First of all, thanks guys for all of your help who ever you are!
Well, now to my problem: I have managed to find a way to transport my arrays to an excel file but some of the values, particulary those bigger than zero are missing the commas that are suposed to be there. For example a 40,35 becomes 4035. You can maybe see it for yourself, I´m attaching the vi.I think it has something to do with my settings in Excel?! Anyway, I appreciate all the help I can get fast!

[Labviewguru]

This is probably due to an international difference in numeric representation.

In the United States, where LabVIEW was created, and Excel for that matter, a decimal point is represented by a period. A comma represents a visual separation of every magnitude of numbers, for example, they are found to identify 1000, 100000, etc, as 1,000, 100,000, etc.

There is probably some miscommunication going on between LabVIEW and Excel. I would suggest that you probably need to replace the comma somewhere with a decimal point. I can't advise how to do this, as I don't know of any way to configure LabVIEW for numeric display (my version appears to only support decimal notation.)

Good luck

[vanja]

You are right about international difference in numeric representation. My Excel wouldn´t except the comma but I found a way to change it. I don´t now if it is the best way but it´s all right with me. Using To Fractional (which I had a problem with) you have a choice: you can set T/F for using a system decimal point! Lucky me! One problem down , certainly more to come 🙂
Thanks for the respond!