Text + Cell value

[Daniel Bonallack]

In column A I have company names
In column B I have values

I want to concatenate the cells in column C, so that the
final value in C1 is, for example, Coca Cola 38.0. How
can I get the value in this concatenated cell to display
to one decimal place?

Thanks in advance
Daniel

 

[Dave R.]

You can either ROUND it or use TEXT and format it to have one decimal.

For round,

=A1&" "&Round(B1,1)

text
=A1&" "&TEXT(B1,"#.#")

 

[Daniel Bonallack]

Thanks!

-----Original Message-----
You can either ROUND it or use TEXT and format it to have one decimal.

For round,

=A1&" "&Round(B1,1)

text
=A1&" "&TEXT(B1,"#.#")




.