Display of float values in Excel

[DDsaaD]

Hello everybody,

i have a question to a faulty representation in my case.

When i use the constant for the upper and lower limit, excel present me a float number with 2 dots (U1) but i use only one dot.

Has anyone an idea whats wrong there,i can't find the reason for this.

Thx

[GerdW]

Hi DMego,

Excel can get confused when it receives several values all formatted as strings.

When you want to send DBL float values to Excel then you should send them as float - not as formatted string!

(Your problem is related to how Excel tries to out-smart the user in choosing the correct formatting for cells.)

I recommend to use a shift register for any reference-type wire crossing loops, like the Excel report reference/class wire…

[RTSLVU]

I always use the %s format specifier.

That way what ever number LabVIEW spits out is formatted into a string exactly the same.

No rounding or truncating decimals or loss of digits of precision.

Excel will still see them as a number

BTW: You can lose the Flat Sequence Structure in your VI and it will operate exactly the same.

THINK DATA FLOW!