[OpenTRV-dev] google spreadsheet

[Bo Herrmannsen]

So i got the serial output in to a spreadsheet...

want to split it up right so its more usefull

raw data: Energy: 102.47


formula: =split(A1; ":"; False)

*result: *102.47.00

have tried to set the format of the result cell to automatic, text,
numbers....

no matter what it added .00

what am i doing wrong?

-- 

                 |||||
               @(~Ô^Ô~)@
-------------oOo---U---oOo-------------
|                                     |
|  Bo Herrmannsen                     |
|                                     |
|                                     |
| "blessed are the "cracked",         |
|  for its they who let in the light" |
|                         Ooo         |
|_________________ooO____(   )________|
                 (   )    ) /
                  \ (    (_/
                   \_)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opentrv.org.uk/pipermail/opentrv-dev/attachments/20140906/f700d08d/attachment.html>