Anyone know how to make a simple PIN generator in excel?
B BigAndy Sep 13, 2005 #2 =RAND()*(9999-1) Try typing this into a cell and change its number properties to having no decimal places.
=RAND()*(9999-1) Try typing this into a cell and change its number properties to having no decimal places.
P Peter Rooney Sep 13, 2005 #3 Jeff, How about entering this formula in a cell, thenRecalcing to generate a new number each time? =INT(RAND()*10000) Regards Pete
Jeff, How about entering this formula in a cell, thenRecalcing to generate a new number each time? =INT(RAND()*10000) Regards Pete
