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.