I have to make 1000 numbers for some gift cards magnetic strip. the numbers
are 14 digits long and the middle 6 numbers are sequential. the first and
last four numbers stay the same for all 1000. The numbers have to be in one
row in excel sot that it can be transfered to the card making machine. how
can i do this without typing all 1000 numbers?

="1234"&TEXT(ROWS($1:1),"000000")&"5678"

Adjust to suit
copy down as far as needed


"how can i sequence the middle numbers" wrote:

I have to make 1000 numbers for some gift cards magnetic strip. the numbers
are 14 digits long and the middle 6 numbers are sequential. the first and
last four numbers stay the same for all 1000. The numbers have to be in one
row in excel sot that it can be transfered to the card making machine. how
can i do this without typing all 1000 numbers?

Hi,

First, you can't do what you stated unless you are using Excel 2007 because
you can put 1000 entries on a row, Excel 2003 only has 256 columns. So it
would be better to put them in a single columns.

Suppose you enter the start number of the central 6 digit number in cell A1
and suppose that number is 100000, suppose that the first four digits are
1234 and you didn't give us any conditions on the last four digits.

In cell B1 enter the formula
="1234"&A1+row()&RANDBETWEEN(1000,9999)
copy this formula down as far as necessary.

RANDBETWEEN is part of the Analysis ToolPak so to use it you need to attach
it - choose Tools, Add-ins, and check Analysis ToolPak.
===============
Now lets suppose you really wanted something totally different - one digit
in 16 consecutive columns:
1. Enter the first four digits in A1:D1
2. In cell E1 enter
=MID(100000+ROW(),COLUMN(A1),1)
3. Copy this to the right to column J.
4. In the next four columns enter any numbers you want
5. Highlight all 16 columns and drag the fill handle down as many rows as
necessary.

If this helps, please click the Yes button
--
Thanks,
Shane Devenshire


"how can i sequence the middle numbers" wrote:

I have to make 1000 numbers for some gift cards magnetic strip. the numbers
are 14 digits long and the middle 6 numbers are sequential. the first and
last four numbers stay the same for all 1000. The numbers have to be in one
row in excel sot that it can be transfered to the card making machine. how
can i do this without typing all 1000 numbers?