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.
Don’t have an account yet? Register yourself now and be a part of our community!