Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INCLUDING A RANDOM NUMBER GENERATOR FIELD
I have created a PO form in Excel and I need to have a field generate a 6
digit random number on the form so it has a unique PO# each time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
INCLUDING A RANDOM NUMBER GENERATOR FIELD
Random is bad because yo will need to track which values have already been
used. Why not start with 100000 and just increment each time -- Gary''s Student - gsnu200748 "RichN" wrote: I have created a PO form in Excel and I need to have a field generate a 6 digit random number on the form so it has a unique PO# each time. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
INCLUDING A RANDOM NUMBER GENERATOR FIELD
Increment would be fine, but how do I set it up? I want it to either print
the incremental number (incrementing up each time I print), or change each time I open it. "Gary''s Student" wrote: Random is bad because yo will need to track which values have already been used. Why not start with 100000 and just increment each time -- Gary''s Student - gsnu200748 "RichN" wrote: I have created a PO form in Excel and I need to have a field generate a 6 digit random number on the form so it has a unique PO# each time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Random number generator | Excel Worksheet Functions | |||
random number generator | Excel Discussion (Misc queries) | |||
Random Number generator | Excel Worksheet Functions | |||
random number generator | Excel Discussion (Misc queries) | |||
Random number generator | Excel Worksheet Functions |