Hi, LibreOffice Calc incorrectly converts currency into text with moneytext formula. When a decimals cents ending at zero, for example. 15,30 €, the result is EUR 15.3, but not text
If this is about the NUMBERTEXT and MONEYTEXT extension then you may want to check with its developers.
If the result is numeric and not text then likely you will just have to assign a number format that explicitly displays two decimals, for example [$EUR] #,##0.00
Hi, format cells have no effect on the outcome-if decimals last digit is “0”, the formula "moneytext"currency in the text converts wrong. I am here a new entrant and so far I can not attach a file to vividly show the problem.
That indicates that the value returned is text, unlike what you wrote. In this case there’s not much you could do in Calc unless you want to append a “0” if there are not two digits following the decimal separator, or “.00” for integer values, which is a bit dirty. For example, =IFERROR(A1&REPT("0",LEN(A1)-FIND(".",A1)),A1&".00") where A1 contains the result of the MONEYTEXT() function. Note that this works only if the decimal separator is ‘.’ dot