Need to add serial number Suffix based on Quantity

[Juxtpos]

Hi,

This has got to be a simple solution.

I'm needing to add a serial number suffix that is based on a quantity.

If I have a prefix in B1 and my QTY in B2, I need to automatically generate serial number suffix, i.e -001 through a max of 1000 in column D.

Is there an easy way to do this? I would like to just be able to put the job specific data in one area and have excel do the rest.

Thanks!

 

[Rick Rothstein]

That works but with the opposite effect. It counts down as opposed to up.

Sorry, I wasn't paying attention. Try this version instead...

=IF(ROWS($1:1)<=B$2,TEXT(B$3+ROWS($1:1)-1,""""&B$1&"""-000"),"")