LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keeping the column constant in a formula Arithmetic functions with embedded text[_2_] Excel Discussion (Misc queries) 4 June 11th 07 03:31 PM
Keeping cell references constant FlyingDutchmanIam Excel Discussion (Misc queries) 1 June 29th 06 11:43 AM
keeping a shape constant regardless of changes in variables Osvy Excel Discussion (Misc queries) 0 March 28th 06 04:49 AM
Auto Fill Series when number ends in -1 JGus Excel Discussion (Misc queries) 7 December 23rd 05 03:14 AM
How do I increment a fill series by a number other than 1? Say I. John Excel Worksheet Functions 3 January 6th 05 09:34 PM


All times are GMT +1. The time now is 08:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"