This is probably an easy one, but is giving me fits. I can get it done using a long series of subs etc., but there has to be an easier cleaner way of doing it.

Floor(Random*587)+1 which of course will produce anumber like 45,4. and need it to show 045,004. Need it to always pad it with 0's.

Floor(Random*587)+1 which of course will produce anumber like 45,4

Huh? Floor(Random*587)+1 will of course ALWAYS return a single integer number. I am not sure what the comma in your example is representing, but your formula will NEVER return a result like that.

To pad a number with leading zeros, you can use:

SerialIncrement ( "000000" ; number )

The result should be Text.

Comment thanks, sorry for the confusion was working with no sleep. The numbers were just meant be be separate examples, not what would be produced together, my bad for not making it clearer.

SerialIncrement ( "000" ; Floor(Random*587)+1 ) works perfect for what I am trying to accomplish.

Thank you again.