Hi All,
We are a manufacturer and are trying to generate an Excel document that will automatically generate a series of sequential codes that we will use to laser etch a data matrix scan code onto a series of products made in a particular batch.
Effectively the sequential code is made up as follows;
We would then like to have an input for how many parts we have made, for instance in a particular batch we made 2,000 widgets, so the input would be 2000.
We then want Excel to generate 2000 codes using the above inputs so that A, BBB, YY, MM, DD and CCCC are static and do not change, but the last four digits that make up the SSSS portion of the code sequentially go up from 0001 to 2000.
We have tried half a dozen different methods, but have not been able to solve this to date...we either get part of the code working, nothing working, or we lose the zeros in front of the SSSS number; i.e. instead of displaying 0001 we just get 1.
Can anyone shed some light on this for me please?
We are a manufacturer and are trying to generate an Excel document that will automatically generate a series of sequential codes that we will use to laser etch a data matrix scan code onto a series of products made in a particular batch.
Effectively the sequential code is made up as follows;
ABBBYYMMDDCCCCSSSS
Where;
A = Code series, which we will start with 1 but could be alpha or numeric.
BBB = Part detail, could be alpha, numeric or alphanumeric.
YY = Year of manufacture, i.e. 23.
MM = Month of manufacture, will need to be two digits such as 01 = January or 11 = November.
DD = Day of manufacture, will need to be two digit to show 01~31.
CCC = Manufacturing batch, could be alpha, numeric of alphanumeric.
SSSS = Sequential series number of parts made, starting from 0001 up to 9999.
We would like to be able to enter in all inputs for the above information A, BBB, YY, MM, DD and CCCC.We would then like to have an input for how many parts we have made, for instance in a particular batch we made 2,000 widgets, so the input would be 2000.
We then want Excel to generate 2000 codes using the above inputs so that A, BBB, YY, MM, DD and CCCC are static and do not change, but the last four digits that make up the SSSS portion of the code sequentially go up from 0001 to 2000.
We have tried half a dozen different methods, but have not been able to solve this to date...we either get part of the code working, nothing working, or we lose the zeros in front of the SSSS number; i.e. instead of displaying 0001 we just get 1.
Can anyone shed some light on this for me please?