Because RAND() returns values from [0...1).

Another way, without the helper column:

http://www.mcgimpsey.com/excel/udfs/randint.html


In article ,
"Matt D Francis" wrote:

Also, don't know if this is normal but the random numbers I generate in Col
A are all decimals, why's that?