How to round numbers with a line break?

[gcon22]

I have this following formula in a cell with Wrap Text selected in Excel:

=(-0.870077889-0.4095)/(-0.0003)&CHAR(10)&"(1.18 hours)"

How do I get the answer "4265.25963" to round to "4265" while keeping the line break and the "(1.18 hours)" looking the same?

[AliGW]

Welcome to the forum.

Try this:

=ROUND((-0.870077889-0.4095)/(-0.0003),0)&CHAR(10)&"(1.18 hours)"

[gcon22]

Welcome to the forum.

Try this:

=ROUND((-0.870077889-0.4095)/(-0.0003),0)&CHAR(10)&"(1.18 hours)"

Thank you!! Works!