Thanks Niranjan.
Neither method worked, so I added a column to the DataTable using the =ABS() formula. So now it outputs the Purchase Request number with the leading zeros, and then reads from the next column with the Absolute value of that number -zeros removed- to create the Purchase Order. -Bodd
UPDATE: I found that you can also Hide the output column in the Data Table using Excel, the scripts work fine and the user will then only see the numbers without leading zeros.
Neither method worked, so I added a column to the DataTable using the =ABS() formula. So now it outputs the Purchase Request number with the leading zeros, and then reads from the next column with the Absolute value of that number -zeros removed- to create the Purchase Order. -Bodd
UPDATE: I found that you can also Hide the output column in the Data Table using Excel, the scripts work fine and the user will then only see the numbers without leading zeros.