Auto Fill Series when number ends in -1

[Guest]

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.

 

[Guest]

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

 

[Gord Dibben]

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

 

[Ken Johnson]

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

 

[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

 

[Guest]

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

 

[Gord Dibben]

This person is definitely a diplomat<g>


Gord

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

 

[Ken Johnson]

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