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.

Just in case something like this would work for you.....

Put 900000824 in the first cell
Change the number format of that cell:
Format>Cells>Number tab
Category: Custom
Type: #0"-1"
Click [OK]

The actual value will be 900000824 , but it will display as 900000824-1

Now try Edit>Fill>Series
You'll see...
90000824-1
90000825-1
90000826-1
90000827-1

Something you can use?

***********
Regards,
Ron

XL2002, WinXP-Pro


"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.
>

Enter your numbers in column A without the -1

In column B enter =A1&"-1"

Double-click on B1 fill handle to copy down.

Select column B and Copy>Paste Special(in place)>Values>OK>Esc.

Delete column A


Gord Dibben Excel MVP

On Wed, 21 Dec 2005 16:49:02 -0800, "JGus" <[email protected]>
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.

Hi JGus,
in A1 =900000823 + Row() & "-1"
then fill down

If you need to start in some other cell, say C10 then use

in C10 =900000824 + Row() -ROW(B$10) & "-1"

the - ROW(B$10) can actually refer to any cell in row 10 but you must
put the $ sign before the 10. Also 900000824, not 900000823 in the
starting cell.

Ken Johnson

Hi JGus,
Alternatively if starting in C10:

=900000823+ROW()-ROW(C$9) &"-1"

to keep the starting figure 900000823 consistent, avoiding confusion.

Ken Johnson

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.
>

This person is definitely a diplomat<g>


Gord

On Thu, 22 Dec 2005 11:19:02 -0800, "JGus" <[email protected]>
wrote:

>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.
>>

We should have bets on which one he used. I'll bet against mine.
Ken Johnson