Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill Series when number ends in -1
We should have bets on which one he used. I'll bet against mine.
Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for Auto Fill | Excel Discussion (Misc queries) | |||
Auto Formatting Custom Number | Excel Discussion (Misc queries) | |||
stop auto fill from thinking for itself!!!!!!! | New Users to Excel | |||
turn off auto fill options box Excel 2003 | Excel Discussion (Misc queries) | |||
Can I auto fill a cell in one worksheet by typing a code number | Excel Worksheet Functions |