Thank you MikeH that solved it.

"Khanjohn" wrote:

I know how to use =Rand() but i need to generate numbers between 2 and 100 or
2 and 20 etc and want whole numbers not 4.6789678. How is this done
please..Brain has quit functions after being up so late.