Based on my limited knowledge, here's what I'd do. The regulars would
probably have a more efficient way of accomplishing this.

Assuming the first 4 digits keep incrementing by 1 and you want this series
in column A:

-Type 2566 and 2567 in cells A1 and A2.
-Select both cells and drag the autofill handle down as far as needed.
-Use a helper column, say column B (or any other convenient column) and type
this formula in cell B1: =A1&"-1"
-Copy this formula down as far as needed.
-Select all cells in column B with formula, copy in place as values.
-Move the contents of B1 to B . . . into A1 to A . . .



"cyndi" wrote:

Hi I am using Excel 2003, Here’s the problem, I need to fill a series keeping
the last number constant: For Example
2566-1
2567-1
2568-1
2569-1
2570-1
Etc…

But I get this instead when I try to autofill it
2566-1
2567-1
2568-1
2566-2
2567-2
2568-2
Is there a way to keep the last number consitant? Any Help would be
awesome. Thanks