data displayed from a spreadsheet not correctly

[remapears]

wow i didn't know the reason for the different looks.. 😛

Okay so I did that and the results in strings and in double are attached (the picture)..

Apparently, the strings show a more accurate value, than those in double (no change) but still the values are not 2.98... it's 0.00298..

Your help is very appreciated!

[altenbach · Accepted solution]

The values in the file are e.g. 2.6855000000000000e-02, which is the same as 0.026855000000000000. (make your string indicators wider to show the entire number!)

You still have not told us about the decimal delimiter setting in your OS. If your numbers typically display with a comma instead of a decimal point, you need to correct for that, e.g. by wiring a FALSE to the top of fract/exp string to number.

You can change the formatting of the numeric indicator to anything you want (e.g. exponential format, number of digits shown, etc.)

[remapears]

Perfect! 

I wired the false constant to that VI and changed the display formating and I got the correct display of the double array 😄

Thank you very much! 😄