software

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:
Formatgt;Cellsgt;Number tab
Category: Custom
Type: #0quot;-1quot;
Click [OK]

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

Now try Editgt;Fillgt;Series
You'll see...
90000824-1
90000825-1
90000826-1
90000827-1

Something you can use?

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

XL2002, WinXP-Proquot;JGusquot; wrote:

gt; I am trying to complete an autofill in excel
gt;
gt; The numbers are 900000824-1, 90000825-1, 900000826-1 to 900001133-1
gt;
gt; I have tried typing 900000824-1 into cell A1, 90000825-1 into cell A2,
gt; 900000826-1into cell A3, when I try to fill I get 900000824-2, 90000825-2,
gt; 900000826-2 in A4, A5, A6 (respectively).
gt;
gt; Have tried to creat a custom fill series with no luck either, any assistance
gt; will be most appreciated.
gt;
gt; Thank you.
gt;

Enter your numbers in column A without the -1

In column B enter =A1amp;quot;-1quot;

Double-click on B1 fill handle to copy down.

Select column B and Copygt;Paste Special(in place)gt;Valuesgt;OKgt;Esc.

Delete column AGord Dibben Excel MVP

On Wed, 21 Dec 2005 16:49:02 -0800, quot;JGusquot; gt;
wrote:

gt;I am trying to complete an autofill in excel
gt;
gt;The numbers are 900000824-1, 90000825-1, 900000826-1 to 900001133-1
gt;
gt;I have tried typing 900000824-1 into cell A1, 90000825-1 into cell A2,
gt;900000826-1into cell A3, when I try to fill I get 900000824-2, 90000825-2,
gt;900000826-2 in A4, A5, A6 (respectively).
gt;
gt;Have tried to creat a custom fill series with no luck either, any assistance
gt;will be most appreciated.
gt;
gt;Thank you.

Hi JGus,
in A1 =900000823 Row() amp; quot;-1quot;
then fill down

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

in C10 =900000824 Row() -ROW(B$10) amp; quot;-1quot;

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 JohnsonHi JGus,
Alternatively if starting in C10:

=900000823 ROW()-ROW(C$9) amp;quot;-1quot;

to keep the starting figure 900000823 consistent, avoiding confusion.

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

quot;JGusquot; wrote:

gt; I am trying to complete an autofill in excel
gt;
gt; The numbers are 900000824-1, 90000825-1, 900000826-1 to 900001133-1
gt;
gt; I have tried typing 900000824-1 into cell A1, 90000825-1 into cell A2,
gt; 900000826-1into cell A3, when I try to fill I get 900000824-2, 90000825-2,
gt; 900000826-2 in A4, A5, A6 (respectively).
gt;
gt; Have tried to creat a custom fill series with no luck either, any assistance
gt; will be most appreciated.
gt;
gt; Thank you.
gt;

This person is definitely a diplomatlt;ggt;Gord

On Thu, 22 Dec 2005 11:19:02 -0800, quot;JGusquot; gt;
wrote:

gt;Thank you to all of you for your suggestions, they all were helpful and I
gt;used the one that suited my needs the best.
gt;
gt;quot;JGusquot; wrote:
gt;
gt;gt; I am trying to complete an autofill in excel
gt;gt;
gt;gt; The numbers are 900000824-1, 90000825-1, 900000826-1 to 900001133-1
gt;gt;
gt;gt; I have tried typing 900000824-1 into cell A1, 90000825-1 into cell A2,
gt;gt; 900000826-1into cell A3, when I try to fill I get 900000824-2, 90000825-2,
gt;gt; 900000826-2 in A4, A5, A6 (respectively).
gt;gt;
gt;gt; Have tried to creat a custom fill series with no luck either, any assistance
gt;gt; will be most appreciated.
gt;gt;
gt;gt; Thank you.
gt;gt;

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