LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

numbers to excel wrong format

My attached vi writes Data in a new excel sheet. As you can see its very simple, but I don`t know how to use active X stuff.

My problem: If I transfer a number like 123,123456 and use %.2f the excel number would be fine, but only 2 numbers after the , appear.
If I use %.6f it makes stupid stuff in excel.
see attached examples.

My goal:
12,456 to 12,456
134,034000 to 134,034
134,000001 to 134,000001

Shouldn`t be so hard to make, but I don`t have a clue.
Download All
0 Kudos
Message 1 of 2
(2,539 Views)
I cannot open your vi. I only use 6.02.
A general problem in LV <-> EXCEL is the fact that Excel is not really using binary numbers (that was my conclusion from tests), but uses ASCII characters, at least for the transfer.
So if you are running a German version of Labview and use the standard decimal character of your Windows (i.e. a comma and not a point) you might still have to use a point when writing numbers to the active X port of Execl.
Check your "Number to fractional String" vi for the input to define the decimal separation character.
Gabi
7.1 -- 2013
CLA
0 Kudos
Message 2 of 2
(2,539 Views)