Sequential Numbering

[Guest]

I want to create a row of 12 numbers with a hyphen between each 4. As I drag down the column, each set of 4 changes sequentially. How do I do this?

 

[Max]

Try this in any cell in row1:

=TEXT(ROW(),"0000")&"-"&TEXT(ROW(),"0000")&"-"&TEXT(ROW
(),"0000")&"-"&TEXT(ROW(),"0000")

copy down

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----

I want to create a row of 12 numbers with a hyphen

between each 4. As I drag down the column, each set of 4
changes sequentially. How do I do this?

 

[Max]

Try playing around with this set-up

Put in B1: =randbetween(0,999)
copy across to E1

Put in A1:

=TEXT($B$1+ROW(),"0000")&"-"&TEXT($C$1+ROW(),"0000")&"-"&TEXT($D$1+ROW(),"00
00")&"-"&TEXT($E$1+ROW(),"0000")

Copy A1 down

Press F9 to re-generate a fresh set of random numbers in B1:E1
The sequential numbering in col A will change accordingly
--
Replace what's in B1:E1 with your own set of random numbers

Adjust this part of the formula:

$B$1+ROW(), $C$1+ROW(), etc

depending on where your start row is,
and what is the number you want to begin the numbering with

 

[Pete]

If you create your first row with numbers in every other
column and putting a hypen in the blank cells of the
skipped columns, then create a second row with the next
sequential number in each of the columns containing
numbers and hyphens in the separating columns, you will
be able to highlight the range of the first two rows and
drag the range downward with the numbers increasing
sequentially.

-----Original Message-----
I want to create a row of 12 numbers with a hyphen

between each 4. As I drag down the column, each set of 4
changes sequentially. How do I do this?