spreadsheet string to array notation

[rodriferfe]

Hi all,

I am using the spreadsheet string to array function and basically my problem is as follows:

My inputs are in scientific notation so I use this in string format. The data is separated with a ",". What I get is just the argument rounded.

As I just realized I didn´t make myself clear I´ve attached a photo of the problem. Notice that probe 4 is the input from which I want to build the array, and probe 5 is the output. I just have the 9 but what happens with the rest of the number?

PD: I´ve tried many formats but none of them seems to work.

Thank for your help

[crossrulz · Accepted solution]

Your system is set up to use a comma (,) as the decimal point?  Try using "%.;%^.3e" for your format.  The "%.;" tells the scan to use the period as the decimal point.

[rodriferfe]

That´s brilliant, it works perfectly, thank you very much for your help!!!!