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

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

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. ``=TEXT(G12/2;"""Bill XYZ requires \$""0.00""  to be set aside each paycheck.""")``