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