[Libreoffice-bugs] [Bug 117002] ISNUMBER is treating the value provided by LEFT as text instead of as a number.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=117002

--- Comment #1 from simm.emanem at gmail.com ---
The result of =LEFT(G6) is '2, not 2. I used  VALUE(LEFT(G6)) to ensure that
the result is 2, not '2. 

=ISNUMBER(VALUE(LEFT(DG6))) is 2.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180413/9c4caaee/attachment.html>