Mix text and numbers with leading zeros

[Susan B]

Good morning,
Trying to create barcodes by putting text (W0410) plus 08, plus a five digit
number beginning with 000001 and incrementing by 1. The leading zeros should
display. The result of the first cell should be W0410 08 000001. The result
of the second cell should be W0410 08 000002. I will need 1,000 so the last
cell should be W0410 08 001000
Formula so far is
=AZCode&" 08 "&CodeStart with AZCode=W0410 and CodeStart being 000000. I
don't know how to increment it and how to not loose the leading zeros.
Thank you,
Susan

 

[Teethless mama]

="W0410 08 "&TEXT(ROWS($1:1),"000000")

copy down as far as needed

 

[Susan B]

They both work wonderfully (I actually used a combination of each).

Thank you so much.

Susan