Sorry, that first formula should have been B5&B6, because of the way you
phrased the question...


"Beege" wrote in message
...
Concatenate means join not add, right?

So, if 1919216111 is in cell B5 and 919216.111 is in B6, then the formula
is B5&B6. But if you mean change the value from one to the other, then
=(B5/1000)-1000000 would work

Beege


"Tennisstar007" wrote in message
...
How can I concatenate 1919216111 to 919216.111