How do i cocantenate with leading zeros and a hyphen

[touque]

I have a large spreadsheet where I have one column with a 6 digit number and the next column with a single digit number. I wish to cocantenate them but need 2 zeros to the left of the 6 digit number and 1 zero to the left of the single digit number and a hyphen between the two like so.

Cell in column A 152470 and cell in column B 2 to end up with 00152470-02 in cell in column C.

I tried using two more columns where formatted those columns so as to read 00152470 and 02 but once I cocantenated the two in a third column I lost the left zeros to read 152470-2 not 00152470-02.

Does anyone have any suggestions?

 

[shg]

=text(a2, "0000000-") & text(b2, "00")

 

[touque]

Worked perfectly!

Thank you very much!!

 

[shg]

You're welcome.

 

[Rick Rothstein]

=text(a2, "00000000-") & text(b2, "00")

I assume the OP noticed that he needed to add an additional zero (shown in red above) in order to produce the 8-digit number he wanted in front of the dash.

Here is another formula that would also work...

=TEXT(100*A2+B2,"00000000-00")