Enter VIP-001 in the first cell then hover the cursor over the bottom
right-hand corner of the cell where there is a small black square calledthe
"fill handle"
When over the fill handle the cursor will change to black cross-hairs,
(don't be confused by tyhe four-headed arrow cursor the appears when you are
on the cell border). Left-click and hold pressed and drag down tghe column
and the numbers will index automatically

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Pammy" wrote in message
...
We have designed tickets and each will have a number:
VIP-0001
VIP-0002
VIP-0003
etc.

Is there something I can set up so the tickets will automatically generate
a
new number so I won't have to go in and manually type them. We have up to
VIP-0500.