Sorry, my mistake, use this

=(A1&TEXT(B1,"00")&TEXT(C1,"00"))*1

as suggested by martindwilson in post #5