View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cyndi cyndi is offline
external usenet poster
 
Posts: 30
Default fill a series keeping the last number constant

Hi I am using Excel 2003, Heres 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