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.

Auto Fill Series when number ends in -1
 

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

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

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

Now try EditFillSeries
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.

Auto Fill Series when number ends in -1
 

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 CopyPaste Special(in place)ValuesOKEsc.

Delete column A


Gord Dibben Excel MVP

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

Auto Fill Series when number ends in -1
 

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

Auto Fill Series when number ends in -1
 

Hi JGus,
Alternatively if starting in C10:

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

to keep the starting figure 900000823 consistent, avoiding confusion.

Ken Johnson

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.

Auto Fill Series when number ends in -1
 

This person is definitely a diplomat<g


Gord

On Thu, 22 Dec 2005 11:19:02 -0800, "JGus"
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.

Auto Fill Series when number ends in -1
 

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