Concatenate Giving Wrong Answer.Multiplies by 10

  • 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

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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!