I was going to suggest something much uglier...

= A1 & "_" & IF(B1<1000,IF(B1<100,IF(B1<10,"000" & B1, "00" & B1),"0" & B1),B1)

smile