I need to join two columns in Excel:

Column A: "A032"
Column B: "00001" (Custom format 00000)

My join is A1 & "_ " & B1 which should result in "A032_00001" but I'm ending up with "A032_1". How can I preserve the leading zeros?