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

On Fri, 26 Nov 2004 17:37:01 -0800, "tjtjjtjt"
wrote:

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

"RescueEMT72" wrote:

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!!!