I have in cell A1 5000
and in cell B1 50
the original figure is 5000,50
Does anyone know a formula in cell C1 that will add cell A1+cell B1 and place the comma as indicated.
I tried Concatenate but it gives 500050 and disregards the comma.
Any ideas?
and in cell B1 50
the original figure is 5000,50
Does anyone know a formula in cell C1 that will add cell A1+cell B1 and place the comma as indicated.
I tried Concatenate but it gives 500050 and disregards the comma.
Any ideas?