Concatenation

[ceb]

I

n excel 2016, ​

I am trying to concatenate text with a number but decimal point but will not show, i.e. "test"&C2 where C2 contains 3.0. I just get Text3 instead of Text3.0. what am i doing wrong?


Cheers Clive

 

[FormR]

Hi, try like this instead.

="Test "&TEXT(C2,"0.0")

 

[ceb]

Hi FormR,

Thanks for our reply but the number in in another cell (E2)
"=D2&IF(C2="INT",".DBW"&E2,IF(C2="REAL",".DBD"&E2,IF(C2="BOOL",".DBX"&E2,"")))

Its only if the Decimal Point is xxx.0

Cheers Clive

 

[FormR]

Thanks for our reply but the number in in another cell (E2)
"=D2&IF(C2="INT",".DBW"&E2,IF(C2="REAL",".DBD"&E2,IF(C2="BOOL",".DBX"&E2,"")))

Hi, simply wrap each instance of the E2 reference with the text function - i.e.

=D2&IF(C2="INT",".DBW"&TEXT(E2,"0.0"),IF(C2="REAL",".DBD"&TEXT(E2,"0.0"),IF(C2="BOOL",".DBX"&TEXT(E2,"0.0"),"")))

 

[ceb]

Hi FormR,

Thanks for that it works fine

Cheers Clive