That should work for Cindy. It would take her a while before the first 4
digits become 5. By then she can easily edit the formula to fit the new
situation.

"Dave Peterson" wrote:

How about this in A1:
=2565+ROW()&"-1"

TRYING wrote:

GORD: Thanks. Even though I wasn't the original poster. I could use the
concept.

However, when I tried to extend the series past 2599-1, I got 25100-1, 25101-1

"Gord Dibben" wrote:

One method..........

Enter this in A1 and drag down

=25&ROW()+65 & "-1"

Copy and paste specialvaluesokesc.


Gord Dibben MS Excel MVP


On Wed, 9 Jan 2008 14:00:07 -0800, 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




--

Dave Peterson