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.