https://bugs.documentfoundation.org/show_bug.cgi?id=145183
m.a.riosv <miguelange...@libreoffice.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |RESOLVED Resolution|--- |NOTABUG --- Comment #10 from m.a.riosv <miguelange...@libreoffice.org> --- Again, a number without decimals, don't have a decimal point. If you insist in your way you need to convert the number in text with A1 format. =LEFT(A7;FIND(".";TEXT(A7;"0.0");1)-1) but then you should search for the decimal separator in your locale, point or comma. In any case there is no bug here. -- You are receiving this mail because: You are the assignee for the bug.