Repeating formula in Excel

R

RescueEMT72

Hi. I need to copy a number into 500 rows, with each number increasing by 1
in value. These numbers are used to track call numbers, so the format is
like this: 2005-001 and I need it to repeat itself up to 2005-0550, and I
don't want to spend the time typing each value in manually. Someone please
help!!!
 
T

tjtjjtjt

One way:
Delete the dash from your number.
Select the cell with the number.
Go to Format | Cells | Number.
Choose Custom and type:
0000-000
click okay.
Then, (still with the same cell selected) go to Edit | Fill | Series.
Make sure the Step Value is 1.
Change to Columns and put a stop value of 2005550.
Click okay.

tj
 
G

Gordon

RescueEMT72 said:
Hi. I need to copy a number into 500 rows, with each number
increasing by 1 in value. These numbers are used to track call
numbers, so the format is like this: 2005-001 and I need it to repeat
itself up to 2005-0550, and I don't want to spend the time typing
each value in manually. Someone please help!!!
Click to expand...

Type in 2005-002 into the next row down, highlight both cells, put the
cursor on the bottom right-hand corner when it will turn into a "+" and
doulble-click. That will put ascending values into all the cells until you
get to the end.
 
G

Gord Dibben

Enter 2005-001 in A1

Right-click on A1 and drag down column A to A550.

Release button and "Fill Series".

Gord Dibben Excel MVP
 
G

Gordon

Gord said:
Enter 2005-001 in A1

Right-click on A1 and drag down column A to A550.
Click to expand...

Interesting. In Excel 2002, right-clicking brings up the context menu and
you CAN'T drag down the column.
 
Top