Concatenate Giving Wrong Answer.Multiplies by 10

JohnDrew · Mar 2nd 2019

Concatenate Giving Wrong Answer.Multiplies by 10. I have a number(A2)= 2.5 and do a Mid function to get the first digit which is in B2= (2), then I have a number in C2=(.5) Then do a Concat and get 20,5 not 2.5. (See Attached) I can get the right answer by dividing by 10 but don't know why.

rabsofty · Mar 2nd 2019

concat works with text values

why not simply add b2 and c2 ?

Why do you want to split a2 and then put it back in e2 ?

if you wanted it as text

Code

=TEXT(B2,"0") & TEXT(C2,".0")

Concatenate Giving Wrong Answer.Multiplies by 10

Participate now!

Share