Concatenate formula.

[serge]

I'm looking for a formula in cell D1 and down, that will add 1 or 2 "0" in front of the ( digit or number ) that when I "concatenate" them together

from cell A1 with B1 see picture or is there another solution ?


Thank you

 

[Yongle]

Try
=1000*A1+B1

 

[serge]

Hi Yongle,

It works well, thank you very much for the help.
Serge.

 

[Yongle]

thanks for the feedback