Enter DG5/07:23 in A1

Left-click on the fill handle and drag across or down and only the 23 will
increment.


Gord

On Sat, 19 May 2007 21:08:03 -0700, Muddled
wrote:

Hey Gord,
You have given me a few answers now. Heres another ??. I Make my quote
numbers with the initials of the person quoting. I would like to make a page
like the ascending number one you just told me how to do. It would have
something like the following for a starting number--- DG5/07:23---. Then I
want excel to make an ascednding list that only increases the 23 to 24 & so
on.
DG