From: Mike Middleton on
Penny Black -

My ideas are the same as I posted in the

(A) Early Excel 2003 had a serious bug in its random number generator. Be
sure to update to Excel 2003 SP3.

(B) You may want to avoid duplicates, in which case search Bing or Google
for "excel unique random numbers" (without the quotes).

- Mike

"Penny Black" <PennyBlack(a)> wrote in message
> Using Excel 2003. Simple task of trying to generate a pseudo-random
> number
> between 1 and 52 (yes, a deck of cards). I'm populating the cells with
> =RANDBETWEEN(1,52). Many of the cells are displaying negative numbers.
> Any ideas?