Lottery Excel

I need to create a lottery system in Excel that brings up 5 randomn numbers in different cells?

BUT I need the system NOT to repeat any of the numbers.

Any know how to do this?
I also want the Random numbers to appear in Autoshapes.

Cheers to all that have answered so far

There is a RAND function in the function wizard that generates a random number between .001 and 1.000 (which can be used in a formula given to you in help to make any random number. Guaranteeing no repeats will require a little more work from you, but nothing you can’t handle with some simple IF statements or by spot-checking by eye.

RAND()*(b-a)+a

This formula will create a random number between a and b.

Go to Insert-> Function, type RAND in the top and push GO, then click ‘help on this function’ at the bottom of that window for more ideas on how to work this. There are a lot of other functions you could use to work on the non-repeating portion of your problem–exactly what to use depends on what you are trying to do.

If you were trying to deal out a hand of cards, for example, one way would be to generate a random number next to each card name that would determine it’s order, then sort it and you have the five cards from the top of the deck.