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.

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.

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.