Random numbers from Excel: Numbers can be selected in Excel using the =RANDBETWEEN formula. A cell containing =RANDBETWEEN (1,5) will select a single random number between one and 5.