LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
JGus
 
Posts: n/a
Default Auto Fill Series when number ends in -1

I am trying to complete an autofill in excel

The numbers are 900000824-1, 90000825-1, 900000826-1 to 900001133-1

I have tried typing 900000824-1 into cell A1, 90000825-1 into cell A2,
900000826-1into cell A3, when I try to fill I get 900000824-2, 90000825-2,
900000826-2 in A4, A5, A6 (respectively).

Have tried to creat a custom fill series with no luck either, any assistance
will be most appreciated.

Thank you.

 
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
Macro for Auto Fill carolini Excel Discussion (Misc queries) 2 December 6th 05 09:11 PM
Auto Formatting Custom Number CSBUG Excel Discussion (Misc queries) 4 November 17th 05 07:57 PM
stop auto fill from thinking for itself!!!!!!! 1vagrowr New Users to Excel 3 November 5th 05 03:27 PM
turn off auto fill options box Excel 2003 martock Excel Discussion (Misc queries) 2 October 13th 05 02:23 AM
Can I auto fill a cell in one worksheet by typing a code number Gomer Pyle Excel Worksheet Functions 1 August 27th 05 01:24 AM


All times are GMT +1. The time now is 12:12 PM.

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"