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