highlight your column, go to Format Cells Number tab Custom
Make the custoemr format 000.

Type in 1, then fill down 1000 times (using the little handle on bottom
right of yoru cell), click the little box on the bottom right, and select
Fill series.

"raffle printing" wrote:

we need to print 1,000 raffles. the ticket number is a three digit i.e 001,
002.

How can we get the number to change for each ticket printed???