<div dir="ltr">So i got the serial output in to a spreadsheet...<div><br></div><div>want to split it up right so its more usefull</div><div><br></div><div>raw data: <span style="color:rgb(0,0,0);font-family:arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">Energy: 102.47 </span></div><div><font color="#000000" face="arial, sans, sans-serif"><span style="white-space:pre-wrap"><br></span></font></div><div><font color="#000000" face="arial, sans, sans-serif"><span style="white-space:pre-wrap"><br></span></font></div><div><font color="#000000" face="arial, sans, sans-serif"><span style="white-space:pre-wrap">formula: </span></font><span dir="auto" class="" style="color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">=</span><span dir="auto" class="" style="color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">split</span><span dir="auto" class="" style="font-weight:bold;color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap;background-color:rgb(229,229,229)">(</span><span dir="auto" style="font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap;color:rgb(247,152,29)">A1</span><span dir="auto" class="" style="color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">;</span><span dir="auto" class="" style="color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap"> </span><span dir="auto" class="" style="color:green;font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">":"</span><span dir="auto" class="" style="color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">;</span><span dir="auto" class="" style="color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap"> </span><span dir="auto" class="" style="color:rgb(17,85,204);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">False</span><span dir="auto" class="" style="font-weight:bold;color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap;background-color:rgb(229,229,229)">)</span></div><div><font color="#000000"><span style="white-space:pre-wrap"><font face="Inconsolata, monospace, arial, sans, sans-serif"><b><br></b></font></span></font></div><div><font color="#000000"><span style="white-space:pre-wrap"><font face="Inconsolata, monospace, arial, sans, sans-serif"><b>result: </b></font></span></font><span style="color:rgb(119,119,119);font-family:arial,sans,sans-serif;font-size:100%;text-align:right">102.47.00</span></div><div><font color="#000000"><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif"><br></font></span></span></font></div><div><font color="#000000"><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif">have tried to set the format of the result cell to automatic, text, numbers....</font></span></span></font></div><div><font color="#000000"><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif"><br></font></span></span></font></div><div><font color="#000000"><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif">no matter what it added .00 </font></span></span></font></div><div><font color="#000000"><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif"><br></font></span></span></font></div><div><font color="#000000"><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif">what am i doing wrong?<br clear="all"></font></span></span></font><div><br></div>-- <br><div dir="ltr"><pre><pre><span style="white-space:pre-wrap"> |||||
@(~Ô^Ô~)@
-------------oOo---U---oOo-------------
| |
| Bo Herrmannsen |
| |
| |
| "blessed are the "cracked", |
| for its they who let in the light" |
| Ooo |
|_________________ooO____( )________|
( ) ) /
\ ( (_/
\_)
</span></pre></pre><pre style="white-space:pre-wrap"><br></pre></div>
</div></div>