Help with sequential numbering

[LorponMC]

[FONT=&quot]HI, I need to create a Excel Database file for work and more importantly I am really terrible at Excel. [/FONT]
[FONT=&quot]I need rows from 1-1000 and only 1 column - that much I know....but it has to be 1000 records of "1/1000" then "2/1000" then 3/1000 and so on all the way to "1000/1000".[/FONT]
[FONT=&quot]So far all i am getting is "1/1000" then 2/1001" then "3/1002".....I need the number in front of the forward slash to change and count up to 1000 and nothing to change after the forward slash.[/FONT]
[FONT=&quot]Thanks in advance for an feedback/help/doing my job for me [/FONT]

 

[Johnny Thunder]

In Column A only enter 1-1000
In column B enter formula =A1&"/1000" and drag this to the bottom of your data

 

[jtakw]

Hi,

Another way.

If you're starting in row 1, use A1 formula copied down.
If you're starting in a row Other than row 1, substract That row number by 1 and replace the "9" in my sample for B10 formula, then copied down.

Book1
	A	B
1	1/1000
2	2/1000
3	3/1000
4	4/1000
5	5/1000
6	6/1000
7	7/1000
8	8/1000
9	9/1000
10	10/1000	1/1000
11		2/1000
12		3/1000
13		4/1000
14		5/1000
15		6/1000
16		7/1000
17		8/1000
18		9/1000
19		10/1000
Sheet321

Cell Formulas
Range	Formula
A1	=ROW()&"/1000"
B10	=ROW()-9&"/1000"

 

[Peter_SSs]

I would be wary of using either of the suggested ROW() formulas. If a row is subsequently added above (for a heading for example) the formulas will return incorrect values.
This slight variation eliminates that possibility
This formula copied down. The red part should be the address of the cell that the first formula is placed in.

=ROWS(A$1:A1)&"/1000"