View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
JGus
 
Posts: n/a
Default Auto Fill Series when number ends in -1

Thank you to all of you for your suggestions, they all were helpful and I
used the one that suited my needs the best.

"JGus" wrote:

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.