ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pin Generator (https://www.excelbanter.com/excel-discussion-misc-queries/45099-pin-generator.html)

GoBucks

Pin Generator
 
Anyone know how to make a simple PIN generator in excel?
--
Jeff

BigAndy

=RAND()*(9999-1)

Try typing this into a cell and change its number properties to having no
decimal places.



"GoBucks" wrote:

Anyone know how to make a simple PIN generator in excel?
--
Jeff


Peter Rooney

Jeff,

How about entering this formula in a cell, thenRecalcing to generate a new
number each time?

=INT(RAND()*10000)

Regards

Pete

"GoBucks" wrote:

Anyone know how to make a simple PIN generator in excel?
--
Jeff



All times are GMT +1. The time now is 07:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com