In Excel 2003 i want to use the fill handle to enter a series of numbers
through x number of rows. I've entered 10000-00, 10001-00, 10002-00 in
B1,B2,B3 then selected those cells and used the fill handle to drag down to
fill cells. When it fills it gives me 10001-01, 10002-01, 10003-01, 10001-02
....ect. I just need the first five digits to increment and leave the -00 at
the end of every number. Is this possible? how?
--
steviebob

That is how text numbers work in Excel

assume 10000-00 in B2, in B2 put

=TEXT(LEFT(B1,5)+1,"00000")&"-00"


copy down

then copy all "number" and paste special as values in place


--
Regards,

Peo Sjoblom



"steviebob" wrote in message
...
In Excel 2003 i want to use the fill handle to enter a series of numbers
through x number of rows. I've entered 10000-00, 10001-00, 10002-00 in
B1,B2,B3 then selected those cells and used the fill handle to drag down
to
fill cells. When it fills it gives me 10001-01, 10002-01, 10003-01,
10001-02
...ect. I just need the first five digits to increment and leave the -00
at
the end of every number. Is this possible? how?
--
steviebob

In B1 enter 10000-00
In B2 enter =--LEFT(B2,5)+1&"-00"
Drag the fill handle (double click it if there are entries in column A)
If needed, Copy and Paste Special (values) to convert formulas to text
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"steviebob" wrote in message
...
In Excel 2003 i want to use the fill handle to enter a series of numbers
through x number of rows. I've entered 10000-00, 10001-00, 10002-00 in
B1,B2,B3 then selected those cells and used the fill handle to drag down
to
fill cells. When it fills it gives me 10001-01, 10002-01, 10003-01,
10001-02
...ect. I just need the first five digits to increment and leave the -00
at
the end of every number. Is this possible? how?
--
steviebob

If you want them all to end in -00 you can put a custom number format of
0"-00" for the first cell and Ctrl drag the fill handle down

Judith
--
Hope this helps


"steviebob" wrote:

In Excel 2003 i want to use the fill handle to enter a series of numbers
through x number of rows. I've entered 10000-00, 10001-00, 10002-00 in
B1,B2,B3 then selected those cells and used the fill handle to drag down to
fill cells. When it fills it gives me 10001-01, 10002-01, 10003-01, 10001-02
...ect. I just need the first five digits to increment and leave the -00 at
the end of every number. Is this possible? how?
--
steviebob

how do you put 10000-00 in B2 and the formula
=TEXT(LEFT(B1,5)+1,"00000")&"-00" in B2?
--
steviebob


"Peo Sjoblom" wrote:

That is how text numbers work in Excel

assume 10000-00 in B2, in B2 put

=TEXT(LEFT(B1,5)+1,"00000")&"-00"


copy down

then copy all "number" and paste special as values in place


--
Regards,

Peo Sjoblom



"steviebob" wrote in message
...
In Excel 2003 i want to use the fill handle to enter a series of numbers
through x number of rows. I've entered 10000-00, 10001-00, 10002-00 in
B1,B2,B3 then selected those cells and used the fill handle to drag down
to
fill cells. When it fills it gives me 10001-01, 10002-01, 10003-01,
10001-02
...ect. I just need the first five digits to increment and leave the -00
at
the end of every number. Is this possible? how?
--
steviebob

Typo, should of course be in B1 and the formula in B2


--
Regards,

Peo Sjoblom



"steviebob" wrote in message
...
how do you put 10000-00 in B2 and the formula
=TEXT(LEFT(B1,5)+1,"00000")&"-00" in B2?
--
steviebob


"Peo Sjoblom" wrote:

That is how text numbers work in Excel

assume 10000-00 in B2, in B2 put

=TEXT(LEFT(B1,5)+1,"00000")&"-00"


copy down

then copy all "number" and paste special as values in place


--
Regards,

Peo Sjoblom



"steviebob" wrote in message
...
In Excel 2003 i want to use the fill handle to enter a series of
numbers
through x number of rows. I've entered 10000-00, 10001-00, 10002-00 in
B1,B2,B3 then selected those cells and used the fill handle to drag
down
to
fill cells. When it fills it gives me 10001-01, 10002-01, 10003-01,
10001-02
...ect. I just need the first five digits to increment and leave
the -00
at
the end of every number. Is this possible? how?
--
steviebob