LabVIEW to Excel - decimal separator issue

[NewbieNick]

I'm using a VI to copy a LabVIEW table to Excel

http://forums.ni.com/ni/attachments/ni/170/125802/1/Write_Table_and_Chart_to_XL.llb

My system uses the comma as a standard decimal separator. Despite changing the LabVIEW settings the table I generate uses a decimal point. When I copy the data values smaller than one are copied correctly, but values > 1 are recognized as the value times a million.

0,9 is still 0,9 but 1,34 is 1340000

Is there any way to resolve this issue

Thanks

[Vsh · Accepted solution]

I ran your VI and everything looks fine for me!!

I get the attached table when I ran the code.

Are you using any non-english keybord? or is there any default settings in Excel with formatted cells? 

Iam using LV8.5, and I changed the range property's value to Value2 in Set Cell Value.vi (since it had a broken arrow) 

         

Message Edited by Vsh on 11-09-2009 02:55 AM

[NewbieNick]

I'm running Win 7 Pro on a German Sony Vaio and (sadly) with a German version of LabVIEW 9

But how does the keyboard effect the decimal settings, and if it does - do I have to make some changes to my Regional / Language options?

[NewbieNick]

Damn, I just changed system locale and settings to English UK and it works fine.

I don't get it, but it still works!

Thanks

[Vsh]

Yeah,

I had faced a similar issue when I was using an Italian keypad. Period, comas, decimal points are at different locations in different language keypads.

I cant tell you what exactly the problem is,

Im glad it helped you. 

Now I am practicing a blindfold typing with an arabic keypad..  

Message Edited by Vsh on 11-09-2009 03:12 AM