Need Help with a repeating list

[yissa]

Hello! I'm really new to excel and need help trying to make a list repeat itself. What I have is a list of htm files and I want each one to add 1 to them but automatically.
Example:

00001.htm
00002.htm
00003.htm
00004.htm

Is there a way to automatically add 5, 6, 7, 8, 9, 10 and so on..... automatically? I'm sorry if it's a stupid question but I would really like to know if I can do this! I have numbers going up to the thousands and would be typing them all day! I'm trying to keep track of web pages for a site as I make them. Thanks for any help from anyone!!

yissa

[swatsp0p]

With the use of a helper column (a blank, unused column--insert one if needed)
you can accomplish your task.

Let's assume your list of data will be in Column A. Insert a new Column B.

In B1 (which should be blank) enter this: .htm
Now in A2 enter '00001 (note the apostrophe in front of the zeros...this is important)
In A3, enter '00002 (again note the apostrophe)
Now, select A1:A2 and using the drag handle in the lower right corner of the cell pointer, drag this down as far as you need (A1000 ?).

Next, in B2, enter this formula:

=A2&$B$1 (here note the $B$1...enter exactly this way)

Finally, drag this down in column B as far as you dragged down in Column A

The result in column B should be:

00001.htm
00002.htm
00003.htm
00004.htm
.....
00999.htm

You can now Hide Col A if you like.

Good Luck

Bruce