In Calc, how do I force ROUND function to always display two decimal places, even when the last digit is zero

[Lauirence5905]

In a LibreOffice Calc spreadsheet, I have a cell that contains the following formula:

=CONCATENATE("Bill XYZ requires $", SUM(G12/2), " to be set aside each paycheck.")

Let’s assume cell G12 is 176.19. The text that is displayed winds up looking like this:

“Bill XYZ requires $88.095 to be set
aside each paycheck.”

Well, clearly that’s not going to work. So I add a “ROUND” to my formula above:

=CONCATENATE("Bill XYZ requires $", ROUND(SUM(G12/2),2), " to be set aside each paycheck.")

Now it displays the following:

“Bill XYZ requires $88.1 to be set
aside each paycheck.”

How do I get it to display TWO decimals? I want $88.10 in there, not $88.1

Thanks for any help you can give.

[mikekaganski]

But what SUM is used there for?

[Lauirence5905]

Thought I needed it to do the calculation G12/2. I had SUM(G12/2) in there, and wanted to round it, so I added ROUND() to the outside of the SUM() function. Didn’t realize I didn’t need to include SUM in there – learn something new every day.

[mikekaganski]

Use TEXT function:

=TEXT(G12/2;"""Bill XYZ requires $""0.00""  to be set aside each paycheck.""")

[Lauirence5905]

Perfect! Thanks so much!