RAND

Copper Contributor

If I use the =RAND() function, I get dates - all the SAME - in the column, not random numbers between 0 and 1. Please help. What am I doing wrong? Have deleted the column, formatting etc and it repeats the same answer.

2 Replies

@KARINDEBEER I suspect that the column where you have the RAND() function is formatted as DATE and you get 1 January 1990 in all cells.

Format as GENERAL and you'll see numbers between 0 and 1.

@KARINDEBEER 

Its is possible that The cell in which =RAND() is format as long or short date. You need to convert it to numbers or general Format.