# 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

Thanks for any help you can give.

edit retag close merge delete

But what SUM is used there for?

( 2019-08-13 15:56:45 +0200 )edit

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. :-)

( 2019-08-13 17:42:23 +0200 )edit

Sort by » oldest newest most voted

Use TEXT function:

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

more