Need to add decimal places to a data value inside of a function

[Tyriel]

I am trying to do a formula that will let me accurately reflect another cells data (with decimals) to a formula line.

The formula now is below.

=T7&X22&B14&"° - ("&(TEXT(B15,"mmm dd")&")")

The problem that I encounter is that in this formula, I am looking for degrees, but if it goes to a whole number it will not place decimal places in the output. EX: B14 is 90.0° but the output will always put 90°.

I am sure that this is an easy fix, but thus far I have been unable to complete it on my own.

[tigeravatar]

Tyriel,

Welcome to the forum!
You can use the Text() function to add trailing decimal 0's like so:
=T7&X22&TEXT(B14,"0.0")&"° - ("&TEXT(B15,"mmm dd")&")"


btw, is your username from Diablo by any chance?

[Tyriel]

Thanks for the help!

It is from Diablo. :D

Have a good one!

[tigeravatar]

You're very welcome, and that's awesome