Text + Cell value

  • Thread starter Thread starter Daniel Bonallack
  • Start date Start date
D

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
 
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,"#.#")
 
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,"#.#")




.
Click to expand...
 
Back
Top