In cell A1 40 (formated as text)
In cell B1 . (formated as text)
In cell C1 23000.14 (formated as text)
When using the wizard to concatenate the three cells together the wizard comes up with the correct answer 40.23000.14. However, the cell is displaying the formula and not the result. =CONCATENATE(A1,B1,C1)
In cell B1 . (formated as text)
In cell C1 23000.14 (formated as text)
When using the wizard to concatenate the three cells together the wizard comes up with the correct answer 40.23000.14. However, the cell is displaying the formula and not the result. =CONCATENATE(A1,B1,C1)