I have to make an excel spreadsheet that has a number in one column and a
corresponding barcode in the next column.

I can add the number in the first cell, drag it down and it will auto
populate in sequential order.
Ex (10000, 10001, 10002....)

Now I need to put the corresponding barcode in the next column. The number
will look like this: *10000*, *10001*,*10002*.... And then I change the
font to a barcode font.

Does anybody know how I can get this to auto populate down the column? The
dragging method does not work.

Any ideas?

Thanks
Jasper