How to use excel or access to do the drawing price for customer

[alex the new IT guy]

my company is going to hold an event which will give away prices for
customer. how do we use excel or access to dothe drawing templete? i have
both office 2003 and 2007.

 

[Bernard Liengme]

Have a look at =RANDBETWEEN(1,1000)
If you get a #NAME! error, try =INT(RAND()*1000)
Both give a random number in the range 1 to 1000
To get a series of random numbers with no duplicates see
http://www.mcgimpsey.com/excel/udfs/randint.html
best wishes